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.
Hi All,
I am trying to calculate a measure for last month same period i.e. if today is 7.2.2019, I want to calculate sum(sales) for last month up to the 2nd day i.e. 6/2/2019. I have researched this and found a formula on most of the posts that I am trying to use but it doesn't give me the correct value.
Any help will be appreciated, thanks in advance!
Formula: Last MTD Sales=
CALCULATE(
Sum('Main'[Sales]),
DATEADD( DATESMTD( Dates[Date] ), -1, MONTH )
)
Solved! Go to Solution.
Hi,
Ensure that there is a relationship between the Date column of the Main Table to the Date column of the Calendar Table. Drag the Date column from the Calednar Table to your slicer/visual and select today's date in the slicer/filter. Write this measure
Last MTD Sales = CALCULATE(Sum('Main'[Sales]),DATESBETWEEN(Dates[Date],EOMONTH(MIN(Dates[Date]),-2)+1,EDATE(MIN(Dates[Date]),-1))
Hope this helps.
Hi,
Ensure that there is a relationship between the Date column of the Main Table to the Date column of the Calendar Table. Drag the Date column from the Calednar Table to your slicer/visual and select today's date in the slicer/filter. Write this measure
Last MTD Sales = CALCULATE(Sum('Main'[Sales]),DATESBETWEEN(Dates[Date],EOMONTH(MIN(Dates[Date]),-2)+1,EDATE(MIN(Dates[Date]),-1))
Hope this helps.
Hi @AJthacker ,
The syntax of the measure seems ok but without any additional information is difficult to understand what you need and what is the final result you are looking for.
Can you share a sample data and expected result?
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsTry this
Formula: Last MTD Sales=
CALCULATE(
Totalmtd(dates[date],Sum('Main'[Sales]),
DATEADD( Dates[Date],-1,MONTH))
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
219 | |
89 | |
76 | |
67 | |
60 |