Solved: Cumulative Total over a month slicer selection.

amunshi · ‎10-10-2021

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

amitchandak · ‎10-10-2021

@amunshi , something like this with date table

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(all(date),date[date] <=max(date[Date])))

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

View solution in original post

amitchandak · ‎10-10-2021

@amunshi , something like this with date table

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(all(date),date[date] <=max(date[Date])))

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

amunshi · ‎10-10-2021

Thanks for the solution.

Regards,

Ashlesha

Cumulative Total over a month slicer selection.

Helpful resources

Power BI Monthly Update - November 2023

Fabric Community News unified experience

The largest Power BI and Fabric virtual conference