Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
Can anyone help with DAX to calculate Total Year to Date for May'20 (I have Report Date slicer) but only for customers who have register status in reporting month. Client want to count all prior months sale even if customer was not registered on the begining of the year, and we should disregard customers sale who are not registered in reporting month.
Here is example data set and expected result for May'20 TOTALYTD sale = $500
My date table/date field is: dim_calendar[date], and 'f_sale' table as below:
Any ideas will help.
Regards,
Agnes
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
You may download my PBI file from here.
Hope this helps.
thank you Ashish it worked.
You are welcome.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |