Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
5 years ago

Accumulated

Hello to see if you can help me with this doubt I have. I have a table with ID, dates per week, and performance (which is already calculated to me), I need to add up every week to get the accumulate...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Syndicate_Admin , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

Usually you accumulative like

 

With date table

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

 

without date table 

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