Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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 , 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
Hi Amit,
I tried the same but I am still facing the issue, Please check my Pbix file if possible.
Thanks
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.
Thanks, I found the issue myself.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |