I was trying to do so in custom filter, for Earliest Date of Each Month even in the power query mode (Data Sources of Pivot table), still not be able to do so. Any suggestions?
I was trying to do so in custom filter, for Earliest Date of Each Month even in the power query mode (Data Sources of Pivot table), still not be able to do so. Any suggestions?
Last edited by mingmac; 03-18-2021 at 12:00 AM.
Might be possible with Power Query, but......
.....Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Done Uploading. THanks.
Try to filter "TRUE" column E, with E3 is:
=AGGREGATE(15,6,$C$3:C3/(TEXT($C$3:C3,"mm/yy")=TEXT(C3,"mm/yy")),1)=C3
Quang PT
I have no idea about PQ.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks