topic Re: calculate ytd in DAX Commands and Tips

calculate ytd

Anonymous — Sat, 08 Jan 2022 11:59:00 GMT

i have two measures of year start date and year end date and i also have total sales but need to calculate ytd with those two measures i cant find correct dax expression for that please help.

thanks

Re: calculate ytd

bcdobbs — Sat, 08 Jan 2022 12:47:50 GMT

At it's simplest you can do something like this:

TOTALYTD ( [Sales Amount], 'Date'[Date] )

You do however need a date table. Have a look at:

https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

From your description however I'm not certain on your requirements. If you provided a demo file I'm sure we can help more.

Ben

Re: calculate ytd

Anonymous — Sat, 08 Jan 2022 13:08:11 GMT

not that simple need to calculate ytd with the two measure as i mentioned above.

Re: calculate ytd

bcdobbs — Sat, 08 Jan 2022 19:32:02 GMT

Can you provide a demo file?

Certainly can be done but needs a lot of the logic writing from scratch.