Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I've automated a report in Power BI that reports on the current month's sales and budget and I've used the relative date filter to show the value in this month. However, it reports on today's budget figure and today's sales which obviously haven't completed yet so it budget includes the whole of today but sales only upto when the report is run.
My question is: Is there a way of reporting the current month but only up to the day before the report? e.g. Today is the 24th of January so I only want to report from the 1st to 23rd of Jan. I also report the last 7 days in more depth and that allows me to exclude today whereas calendar month doesn't give me that option.
Thanks in advance for your suggestions.
Solved! Go to Solution.
Take a good look at this discussion.
http://community.powerbi.com/t5/Desktop/Relational-Date-Filter-By-Other-Date-How-To/td-p/298373
Thanks very much for the feedback. Unfortunately it doesn't quite work as the budget is pre-populated right though this year so I'm still seeing data for today!!! Also the data warehouse updates every half an hour so when sales come through for today it populates the report. Is there a way of purely selecting this month except for today so I can bring in MTD sales and budget?
Kind regards
Take a good look at this discussion.
http://community.powerbi.com/t5/Desktop/Relational-Date-Filter-By-Other-Date-How-To/td-p/298373
That's great. Thanks for your help.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
179 | |
108 | |
105 | |
71 | |
70 |