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.
Hi All.
Hoping you can help. I have a series of sales reports that i would like to auto update each month to show the current months sats only.
At present I have to go into the report each month and manually set the dates for that month.
I am using a date dimenion table which should hopefully make it easier. I just cannot work out how to do this.
Any help really appreciated.
Thanks
Craig
Solved! Go to Solution.
Hi @CraigBlackman,
About dynamic date filter, you can take a look at below blog with power query dynamic date filter.
PowerQuery Dynamic Date Dimension Table Filtering
Regards,
Xiaoxin Sheng
Hi @CraigBlackman,
About dynamic date filter, you can take a look at below blog with power query dynamic date filter.
PowerQuery Dynamic Date Dimension Table Filtering
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 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |