TOTAL LYTD

[Anonymous]

Hey Guys,

I´am trying to calculate Sales LYTD.

Sales YTD = 

TOTALYTD(SUM(Sales_Table[Sales Amount]),'Date Table'[Date])

This formula works perfectly but i can´t figure out how to calculate it for last year.

Please help!!!!

[Anonymous]

So far i have a solution in case of the usage in a table, but it is not working for my visual...

1.TOTAL_YTD(SUM(Sales_Table[Sales Amount]),'Date Table'[Date])

2.Revenue FY = SUM(Sales Table[Sales Amount])

3.TOTAL_LYTD(Calculate([Revenue FY],DATESYTD(Date Table[Date])

The visual card should actualy show 35.117k...the only way it does it is if i choose relative time filter on the visual "in this month"

Does anyone know how to get it done without filtering the visual?

[Anonymous]

Hi @Anonymous ,

Please try like:

Revenue PY YTD =
VAR _year =
    YEAR ( TODAY () ) - 1
VAR _month =
    MONTH ( TODAY () )
VAR _lytd =
    CALCULATE (
        [Revenue FY],
        FILTER (
            ALL ( 'Date Table' ),
            'Date Table'[Year] = _year
                && 'Date Table'[Month Number] = _month
        )
    )
RETURN
    _lytd

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[Anonymous]

Hi @Anonymous 

unfortunately this doesn´t work. I gues for now i will go with the workaround. Thank you very much anyway!