Forum Discussion
dynamic date
Hi, abc_777
Thank you for your feedback, and sorry that I did not recognize the backward cumulate.
Please check the below picture, the measure, and the link down below.
https://www.dropbox.com/s/cd59ags3a8zk4x3/abc.pbix?dl=0
QTY Total N days backward cumulate =
IF (
NOT ISBLANK ( [QTY Total N days] ),
CALCULATE (
[QTY Total N days],
FILTER (
ALLSELECTED ( 'Calendar' ),
'Calendar'[Date] >= MAX ( 'Calendar'[Date] )
)
)
)Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: www.linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
Hi, abc_777
Please check the below picture and the sample pbix file's link down below.
All measures are in the sample pbix file.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Hi Jihwan_Kim ,
yours is perfectly works and it can clean previous data just showing the data that you want to see. ut its not cumulatively aggregate or summing and goes backward. if you see my first post it was cumulatively going backward.. so have any solution?
Hi, abc_777
Thank you for your feedback, and sorry that I did not recognize the backward cumulate.
Please check the below picture, the measure, and the link down below.
https://www.dropbox.com/s/cd59ags3a8zk4x3/abc.pbix?dl=0
QTY Total N days backward cumulate =
IF (
NOT ISBLANK ( [QTY Total N days] ),
CALCULATE (
[QTY Total N days],
FILTER (
ALLSELECTED ( 'Calendar' ),
'Calendar'[Date] >= MAX ( 'Calendar'[Date] )
)
)
)Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: www.linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM