Seek help in convert YTD to LYTD

[Paulyeo11]

Hi All

I have below expression from Mr Ash :-

YTD Total = if(ISBLANK([Total]),BLANK(),if(MIN('Date'[Date])>today(),BLANK(),CALCULATE([Total],DATESYTD('Date'[Date],"31/12"),ALL('Table'[GL CODE]))))

Can some one help me convert above the LYTD.

Paul

[v-deddai1-msft]

Hi @Paulyeo11 ,

You can use something like:

YTD Total =
IF (
    ISBLANK ( [Total] ),
    BLANK (),
    IF (
        MIN ( 'Date'[Date] ) > TODAY (),
        BLANK (),
        CALCULATE (
            [Total],
            DATEADD ( DATESYTD ( 'Date'[Date], "31/12" ), -1, YEAR ),
            ALL ( 'Table'[GL CODE] )
        )
    )
)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[Paulyeo11]

Hi Sir

I still get error on Total .

https://www.dropbox.com/s/xr0lb692d2yv81o/HOW%20TO%20COMPUTE%20REVENUE%20YTD%20V0006.pbix?dl=0

Above is my PBI file 

[v-deddai1-msft]

Hi @Paulyeo11 ，

You don't have Total column or Total measure in your data model. Use the formula I suggested above.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[Paulyeo11]

Hi Sir

Very sorry that i am still lost. If i use the expression again , it will be still error.

Paul

[manikumar34 · Accepted solution]

@Paulyeo11 , 

That is working fine, I did check on that. Refre the below screenshot. LYTD is 10. Refre second for the value in table for 2019 as well. 

Both the values are same and attaching file for you reference. 

https://www.dropbox.com/s/qqembxhjv7d8aos/HOW%20TO%20COMPUTE%20REVENUE%20YTD%20V0006.pbix?dl=0

Regards, 

Manikumar

[Paulyeo11]

Hi Mani

Thank you very much , now the value appear . I need to further check on it later.

Paul

[Paulyeo11]

Hi Ded

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

My PBIX file :-

https://www.dropbox.com/s/q93wobh5avy7n9b/HOW%20TO%20COMPUTE%20REVENUE%20YTD%20V0005.pbix?dl=0

[v-deddai1-msft]

Hi @Paulyeo11 ，

Would you please use the following one:

YTD Total = 
IF (
    ISBLANK (SUM('Table'[AMOUNT]) ),
    BLANK (),
    IF (
        MIN ( 'Date'[Date] ) > TODAY (),
        BLANK (),
        CALCULATE (
           SUM('Table'[AMOUNT]),
            DATEADD ( DATESYTD ( 'Date'[Date], "31/12" ), -1, YEAR ),
            ALL ( 'Table'[GL CODE] )
        )
    )
)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai