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])))

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

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])))

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

amunshi · ‎10-10-2021

Thanks for the solution.

Regards,

Ashlesha

Cumulative Total over a month slicer selection.

Helpful resources

Fabric Community Update - November 2024

Be one of the first to start using Fabric Databases

Join us at the Microsoft Fabric Community Conference

Power BI Monthly Update - November 2024

Be one of the first to start using Fabric Databases.