Forum Discussion
Recreating an Existing Report with a new dataset
Anonymous , Hope ModelCalendar is marked as a date table, having all the dates required. You should COlumn from ModelCalendar in Visual, slicer, and measures(seem like using in measure)
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
Hi everyone
Ashish_Mathur , I was unable to upload the requested information due to the business nature of it. amitchandak thank you for the video links.
I have solved this issue as I was watching the video guidance and thinking on how one set of data was working and one was not. The issue I had created was the format of the date. In the first set of data, from Excel, the time was removed from the Date field. When I extracted the data from the cloud system, all I needed to do was transform the Date field to Date only, link with the Calendar table on the Date field and the queries worked perfectly. Than you for the help and guidance.