Forum Discussion
Solved
Aggregating measure based on dates
Hi I am working with invoice level data but am trying to create a measure which applies conditions at the aggregated customer level within a period. Example below shows invoice $ by customer and ...
If you look at the PBIX file I loaded, I add both.
The first is a calculated column to the 4 column table
Within Terms = IF('Table1'[Overdue]=0,"Y","N")
If you look at the PBIX file I loaded, I add both.
The first is a calculated column to the 4 column table
Within Terms = IF('Table1'[Overdue]=0,"Y","N")
Thanks Phil - works well. Am npw trying to get a count of how many customers meet this criteria within a period or within a division which I can do but am having issues with getting the count to work at Grand Total level. In this eg the total should be 1 (ie Cust B). Thanks again in advance.