Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |