topic Need help in dax in DAX Commands and Tips

Need help in dax

Nihed — Wed, 30 Mar 2022 19:26:05 GMT

Hello,

Please how i can change KPI selection from Year(2022) and Year N-1(2021) to YTD and YTD N-1

these are the columns I have to use :

Re: Need help in dax

amitchandak — Thu, 31 Mar 2022 02:07:06 GMT

Nihed , if you need two measures, You can try

example

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))
Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))

Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA

Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs

Re: Need help in dax

v-janeyg-msft — Wed, 06 Apr 2022 07:42:09 GMT

Hi, Nihed

Have you take amitchandak 's advice? If your problem has been solved, you can mark the answer as solution to close the thread. If not, Is your YTD a full year? please add more details and feel free to ask me.

Best Regards,
Community Support Team _ Janey