Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi.
I have a requirement wherein I have a slicer containing months.
I want to display a KPI containing cumulative total for the selected month.
Any help would be appreciated.
Regards,
Ashlesha
Solved! Go to Solution.
@amunshi , something like this with date table
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(all(date),date[date] <=max(date[Date])))
@amunshi , something like this with date table
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(all(date),date[date] <=max(date[Date])))
Thanks for the solution.
Regards,
Ashlesha
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
30 | |
16 | |
14 | |
14 | |
9 |