Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Dear Power Bi Gurus,
I have set up my model to count Month To Date values for this Year and Last Year as shown at the picture.
This is possible by manually selecting on a "Date Hierarchy" slicer. My results are correct this way.
However, as this will be a daily automated report, I would like to always have Yesterday Date as my most recent date on my Month to Date calculations.
This way my report will always reflect the "Start of Month - Yesterday" time period.
Could you please help me on how to automatically have yesterday as my last date?
Thank you in advance.
Solved! Go to Solution.
Dear @airportGR ,
I enriched the sample data as follows.
The following formula should do it for the last year.
if you want to have it for two years ago please change the "YEAR(TODAY())-1" to "YEAR(TODAY())-2".
Did I solve your requests? Please mark my post as solution.
Appreciate your Kudos.
Best regards
Mikelytics
Dear @Mikelytics
Solution 1 works perfectly fine without any selection needed on the slicer
Solution 2 in order to work the slicer has to be selected (specific date ie 16/1/2021)
I am moving forward with Solution 1 (many thanks!)
Could you please advise on how to have the same MTD results for -1 and -2 years back (following Solution 1)
Thank you very much
Dear @airportGR ,
I enriched the sample data as follows.
The following formula should do it for the last year.
if you want to have it for two years ago please change the "YEAR(TODAY())-1" to "YEAR(TODAY())-2".
Did I solve your requests? Please mark my post as solution.
Appreciate your Kudos.
Best regards
Mikelytics
Dear @Mikelytics following your Solution 1 and adding the extra code for Last Year (-1) and (-2) solved my problem.
Thank you very much, I hope that this thread will help others too.
Hi @airportGR ,
did you try to solve this by putting the filter in the measure? I have two possible solutions based on the following sample data.
(in Power BI I deleted the first row from the sample data)
Solution 1: if you want to use it in a KPI visual
Solution 2: if you want to use it in a table or similar:
Hope this helps.
Best regards
Mikelytics
--------------------------------------------------------------------------------------------------------------------------
Did I solve your requests? Please mark my post as solution.
Appreciate your Kudos.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
98 | |
69 | |
46 | |
39 | |
33 |
User | Count |
---|---|
157 | |
101 | |
60 | |
43 | |
40 |