How to compute Amount before Today ?

[Anonymous]

Hi All

My PBI File :-

https://www.dropbox.com/s/gxnx7xrfw62b99s/BEFORE%20TODAY%20AMOUNT.pbix?dl=0

[Anonymous · Accepted solution]

Hi @Anonymous 

calculate(sum([Total Amount]),[closing date]<TODAY())

[Anonymous · Accepted solution]

Hi @Anonymous 

calculate(sum([Total Amount]),[closing date]<TODAY())

[Anonymous]

Hi Sir

Thank you for your sharing , i get error msg :-

[Anonymous · Accepted solution]

@Anonymous - you are missing a braces")" in the last.

Add a ) in the last and it will resolve  the error.

Appreciate your kudos!! Mark this post as solution if this helps.

[Anonymous]

Hi Sir

Thank you it work fine.

Column = CALCULATE([Total amount],CRM_TS_[Closing Date]<TODAY())