Facing issue with YTD and MTD

[deepakv]

Hi Team, When I am working with YTD. I am facing some issues Using quick measure I was able to get this error as it says 

"Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."

Could you please help? 

YTD = CALCULATE([Totalsales],DATESYTD(DATE[FISCAL_DATE].[Date]))

Regards,

Deepak

[deepakv]

Can you please let me know what might be the issue?

[v-easonf-msft]

HI, @deepakv 

Can you show the formula you are currently using for measure [Totalsales]?

Is "FISCAL_YEAR" a field of your table 'Date'?

If possible, please share your sample file.

Best Regards,
Community Support Team _ Eason

[deepakv]

I am not facing any issues, but am not able to slice as the values are constant.

Upon filters, the values are not reflecting/changing.

[Anonymous]

First of all, You must have a DATE table

2) Declare this table as DATE TABLE

3) Create relationshuip between your date table and your fact table

and change the measure

YTD = CALCULATE([Totalsales],DATESYTD(DATE.[Date]))