Forum Discussion

algoritmia_pbi's avatar
algoritmia_pbi
Regular Visitor
3 years ago
Solved

roll up values in column

Hi I have a dataset like the following and would like to have something similar to the third column   Date                     Sales             Column I need: Sales rollup March 1                ...
Need Help
Show and Tell
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
3 years ago

algoritmia_pbi 

pls try this

 

Measure = sumx(FILTER(ALL('Table'),'Table'[date]<=max('Table'[date])&&YEAR('Table'[date])=YEAR(MAX('Table'[date]))&&MONTH('Table'[date])=MONTH(MAX('Table'[date]))),'Table'[Sales2])

 

pls see the attachment below