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.
Is it possible to create a dynamic date filter in a DAX expression where the result would be to have filter selections you can click for:
- Year to Date
- Last Month
- Last Week
- Last Day
Solved! Go to Solution.
HI @Cognosben,
I'd like to suggest you take a look at below link which has the similar requirement:
Calculating Averages for the same data for different time buckets (Daily/Weekly/Monthly)
Regards,
Xiaoxin Sheng
HI @Cognosben,
I'd like to suggest you take a look at below link which has the similar requirement:
Calculating Averages for the same data for different time buckets (Daily/Weekly/Monthly)
Regards,
Xiaoxin Sheng
Hi @Anonymous
Thank you for reply.
I have created the help table and the measure underneath but cannot get it to work. The measures are not showing when I put FilterMeasure into a graph. The individual measures are working as they should. What might be wrong?
FilterMeasure = IF(HASONEVALUE(Filter_Date[Filter]);SWITCH(VALUES(Filter_Date[Filter]);"YTD";[YTD_Number];"MTD";[YTM_Number];[YTD_Number]))
Hi @Cognosben
Does the FilterMeasure work outside of a graph? In a table for example or in Card visual?
In the graph, what dates do you have on the axis? Could you post a picture or link a file and i can have a look.
Best regards,
Gustav
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |