DatesYTD returns Blank?

[m_aatif]

In powerPivot Window, Dax measures , following measure returns blank. I have been trying to do it for a long time but no succes.

I have contagious date table.
It has been marked as "date"
I have set relationship of many to one.


YTD:=CALCULATE([TotalSales],DATESYTD(Calendar[Date]))

Please help

 

[Matt Allington]

This measure only returns a value when it is used in a Pivot Table.
Insert a new Pivot table in Excel connected to the data model
set up the pivot table so that you have Calendar Year on Rows.
Place Calendar Month Number beneath Year on rows.
Put Total Sales in the values section
put your YTD measure in the values section.

Then you should see it work.

I recommend you never write measures in the Power Pivot window when you are learning.
Always set up a pivot table with a relevant context for the task at hand (in this case you need to see some sort of time period of sales to check it works)
When you are an expert, then it is fine to write them how you like. When you are learning, I suggest you do it this way.

Matt

 

[m_aatif]

Thank you very much Matt, Its working.