How to add 1 condition to my YTD expression ?

[admin11]

Hi All

https://www.dropbox.com/s/z96whnemcu6y398/PBT%20GL%20VER0023%20ask%20how%20to%20get%20LYTD%20REV.pbi...

Above is my PBI file :-

Paul Yeo

[themistoklis · Accepted solution]

@admin11 

You can add another calculate function:

_YTD REV = CALCULATE(CALCULATE(GL[AMOUNT],DATESYTD('Date'[Date],"12/31")), dimension = "iiiii")

[admin11]

Hi Themis

Thank you very much it work fine.

Paul