Forum Discussion
Helper IDAX QTD not working (empty)
Hello
I used Bravo to generate some Time Intelligence metrics in Power BI DAX and it has worked great.
However when year changed to 2024 some calculations stopped working. I would like to focus on this:
Thanks in advance
calloni , The only reason I can think of that YTD is working and QTD is not working is that you do not have a date filter on the page, also visual is not using any period from Calendar. In such case, TD functions take the last date in the calendar. I am assuming your calendar is till year end and such case datesqtd will give the last qtr of the year and will not show data.
In such cases better default page with the current month or qtr( You can use relative date slicer for that)
Why DATESMTD is still blank, even after having correct TI Setup: https://youtu.be/j0ug-XQgZtg
Why previousmonth does not give result when datesmtd -1 1 month is giving it: https://youtu.be/1KkoJehRVeg
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
6 Replies
calloniHello Thanks for your message
I created a Measures Table and opted to put all calculations there so I can go in one place to see all measures. This data model is very complex, but thanks for your suggestion.
I am looking to get the total downloads for the current quarter (Q1 2024). YTD works fine, but QTD doesn't (from the calculations I got from Bravo).
Thanks
Rodrigo
- amitchandak
Super User
calloni , The only reason I can think of that YTD is working and QTD is not working is that you do not have a date filter on the page, also visual is not using any period from Calendar. In such case, TD functions take the last date in the calendar. I am assuming your calendar is till year end and such case datesqtd will give the last qtr of the year and will not show data.
In such cases better default page with the current month or qtr( You can use relative date slicer for that)
Why DATESMTD is still blank, even after having correct TI Setup: https://youtu.be/j0ug-XQgZtg
Why previousmonth does not give result when datesmtd -1 1 month is giving it: https://youtu.be/1KkoJehRVeg
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
- Greg_Deckler
Community Champion
calloni I would avoid the TI functions entirely. DAX TI functions are an utter abomination and anyone/anything that suggests using them is off base. You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000
Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008- calloni
Thanks for the candid reply Greg.
I am coming from a Tableau world where all this is pretty straight forward and the learning curve is pretty deep. That's why I had some friends recommending using Bravo for Time Intelligence and was really helpful until I saw this problem.
I will take a look at your video and see if I can learn anything as DAX is really a language more devoted to programmers than to folks from human related areas like myself. I have SQL experience and worked with data for a while, Tableau was a liberation for me, but the move to PBI DAX is really combersome.
Rodrigo
