Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Solved! Go to Solution.
HI @Anonymous,
Maybe you can try to use date function instead of time intelligence functions in your formula. They not required a calendar table and can be nested with other functions.
BTW, can you please share some dummy data to test?
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Hi @Anonymous,
You can consider adding a visual level filter on your cards to filter on specific data ranges or write switch functions in your dax expressions then it can return different results based on its row contents.
Add a filter to a report in Power BI
Regards,
Xiaoxin Sheng
Also, do you have a date table?
Proud to be a Super User!
These should help you
https://docs.microsoft.com/en-us/dax/previousmonth-function-dax
https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000
Proud to be a Super User!
Thanks for the good information. I have a data table but my measure is this:
HI @Anonymous,
Maybe you can try to use date function instead of time intelligence functions in your formula. They not required a calendar table and can be nested with other functions.
BTW, can you please share some dummy data to test?
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
183 | |
111 | |
105 | |
77 | |
70 |