Time Intelligence function

[azeemnazim]

 https://drive.google.com/file/d/15bz4a5Pq5bsgNZuE68eTeKWwNrDmNsdo/view?usp=sharing 

Hi,

I have been facing serious issues while creating the time intelligence function in the above-mentioned file. The calendar table that I have created is perfectly fine but I am facing issues when I use a DatesMTD  using the mentioned  formula 

MTD Sales = CALCULATE([Sum sales],DATESMTD(Calender[Date].[Date])) , but I am getting no values I have also created a table for reference in the above-mentioned path to the Pbix file. I have also been facing issue with the calendar table as the value picked up from the calendar table and my fact table does not show value please help me in this and what is causing this issue.

Thanks 

Azeem

[amitchandak · Accepted solution]

@azeemnazim , please avoid using . Date

Ventas MTD: CALCULATE([Sum sales],DATESMTD(Calender[Date]))

Power BI — YTD
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
Power BI — QTD
https://medium.com/@amitchandak.1978/power-bi-qtd-questions-time-intelligence-2-5-d842063da839
Power BI — MTD
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e

[azeemnazim]

Hi Amit,

I tried the same but I am still facing the issue, Please check my Pbix file if possible.

Thanks

[azeemnazim]

If possible can you please check why I am not getting any values when I am using date from calendar table and just selecting sales in table its not giving any values.

[azeemnazim]

Thanks, I found the issue myself.

[v-yingjl]

Hi @azeemnazim ,

Glad to hear the issue is solved. You can kindly share your solution and accept your reply as solution, that way, other community members could easily find the answer when they get same issues.

Best Regards,
Yingjie Li