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.
Whats the best way to filter a visual to data from only the current month. Would it be to create a measure filtering on latest month or is there an easier way?
Proud to be a Super User!
Solved! Go to Solution.
Hi @vanessafvg,
You can simply to create a calculated table to filter data with today function, then use this new table as the source of visual.
Current Month = CALCULATETABLE(DateTable,FILTER(ALL(DateTable),FORMAT([Date],"mm yyyy")=FORMAT(TODAY(),"mm yyyy")))
Notice: original datetable contains date from 2015 to 2017, after above steps, it only contains current month data.
Regards,
Xiaoxin Sheng
Hi @vanessafvg,
You can simply to create a calculated table to filter data with today function, then use this new table as the source of visual.
Current Month = CALCULATETABLE(DateTable,FILTER(ALL(DateTable),FORMAT([Date],"mm yyyy")=FORMAT(TODAY(),"mm yyyy")))
Notice: original datetable contains date from 2015 to 2017, after above steps, it only contains current month data.
Regards,
Xiaoxin Sheng
Hi tried the formula but got this error: "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."
Here's my formula: Current Month = CALCULATETABLE(hd_backorders, FILTER(ALL(hd_backorders), FORMAT(hd_backorders[hd_estfulfillmentdate], "mm yyyy") = FORMAT(TODAY(), "mm yyyy")))
Hi everyone.
This functionality hasn't always been there, but if you have a proper formatted date column or better a dedicated date table, you can simply use the relative date filtering. See below:
Create a calculated column on your date table to identify current month and past month.
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |