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.
Hi,
As far as I’m concerned, I think you can first try to create a calendar table to connect it to the main table, you can follow this link:
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/
You can also refer to this solution provided from the Power Bi support in a solved case:
https://community.powerbi.com/t5/Service/Time-intelligence-does-not-work/td-p/279520
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
According to your DAX code ISFILTERED([Date]), Did you set any filter on your Date column?
Appreciate your Kudos!!
No, no filters applied
Can you swap the True and False codes in the IF formula and check that again?
Is it possible to share the PBIX file [after removing the sensetive data]?
Appreciate your Kudos!!
I have tried removing IF filtered sentence and tried running it but the visual look quite iffy.
I couldn't attach the file here so https://drive.google.com/file/d/11UCq-ZxQiOzeMqCBoIs8aroLqBJ7IApv/view?usp=sharing attached a link here but unsure if that can be accessed?
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 |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |