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.
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
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |