calculate ytd

[Anonymous]

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

[Anonymous]

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

[bcdobbs]

Can you provide a demo file?

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

[bcdobbs]

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