Forum Discussion

wagadd's avatar
wagadd
Frequent Visitor
3 years ago
Solved

Totalytd not working

YTD value = TOTALYTD(SUM('Du P&L'[ Value ]),'Du P&L'[Date].[Date])   Dears , please help undertanding why the ytd is not working
Need Help
  • wagadd's avatar
    wagadd
    3 years ago

    thanks , i got this solution from Chat gpt : 

    YTD Value =
        VAR CurrentYearQuarter = Sheet2[Year] & "-" & Sheet2[Quarter]
        RETURN
            CALCULATE(
                SUM(Sheet2[Value]),
                FILTER(
                    ALL(Sheet2),
                    Sheet2[Dashboard] = EARLIER(Sheet2[Dashboard]) &&
                    Sheet2[Type] = EARLIER(Sheet2[Type]) &&
                    Sheet2[Year] = EARLIER(Sheet2[Year]) &&
                    Sheet2[Year] & "-" & Sheet2[Quarter] <= CurrentYearQuarter &&
                    Sheet2[Scenario] = EARLIER(Sheet2[Scenario]) &&
                    Sheet2[Order] = EARLIER(Sheet2[Order])
                )
            )
wagadd's avatar
wagadd
Frequent Visitor
3 years ago

thanks , i got this solution from Chat gpt : 

YTD Value =
    VAR CurrentYearQuarter = Sheet2[Year] & "-" & Sheet2[Quarter]
    RETURN
        CALCULATE(
            SUM(Sheet2[Value]),
            FILTER(
                ALL(Sheet2),
                Sheet2[Dashboard] = EARLIER(Sheet2[Dashboard]) &&
                Sheet2[Type] = EARLIER(Sheet2[Type]) &&
                Sheet2[Year] = EARLIER(Sheet2[Year]) &&
                Sheet2[Year] & "-" & Sheet2[Quarter] <= CurrentYearQuarter &&
                Sheet2[Scenario] = EARLIER(Sheet2[Scenario]) &&
                Sheet2[Order] = EARLIER(Sheet2[Order])
            )
        )