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.
Hello, hoping someone can help.
I am looking to create a function that allows the month value displayed on a table to actually refer to all data on or before the month displayed. This is in order to simulate point in time compliance figures.
For example, May 2021 would actually show all data from the end of May 2021 backwards. January 2021 would similarly show from the end of January 2021 backwards.
Hope this helps explain my issues 🙂
Thanks
@Greig_Dunbar , are you looking for cumulative?
example
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[Date])))
Cumm Sales till month back= CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=eomonth(max(date[Date]),-1) ))
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |