YTD in Power query

[Nihed]

Hello,

Please how I can calculate YTD in power query ,what is the syntax please (urgent)

Thank you

[v-yiruan-msft]

Hi @Nihed ,

You can also refer the following links to get it by DAX:

Power BI Tips: Calculate Year-to-date Values

YTDSumOfSales = TOTALYTD([SumOfSales],’Calendar'[Date])

How to Create YTD Calculations in Power BI​

Sales YTD =
TOTALYTD(
    SUM(Orders[Sales]),
    Orders[Order_Date],
    ALL(Orders)
)

Best Regards

[ribisht17 · Accepted solution]

@Nihed 

Please check this one https://powerusers.microsoft.com/t5/Power-Query/YTD-sum-of-columns-in-Power-Query-based-on-input-fro...

Thanks,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!

My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users