Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Charline_74
Helper III
Helper III

Measure + Date

Hello 
I need to create measures enabling me to obtain
the sum of my sales :
- the current month -2 months from last year (for example, it's November 2023 and I want to display my total sales for September 2022)
- the last month of last year (e.g. it's 2023, I want to display my total sales for December 2022)
- the current month -1 month (e.g. it's November 2023, I want to display my total sales for October 2023)
- the current month

I need these measures to be dynamic.

I have a table with a sales column and a date column.

1 REPLY 1
Surya9
Resolver III
Resolver III

sales for current month -14 months 
var a = min(date[date])  -- to get the minimum selected Date
_StartDate = EDATE(a,-14)  -- startdate Before 14 months

_Enddate = EOMONTH (_StartDate,0)  -- EndDate of 14th month
 return calculate(sum[Sales],FILTER(ALL('Date'),'Date'[Date] >=_StartDate && 'Date'[Date] <= _Enddate))

use the above same measure for previous one moth sales calculation just replace -14 with -1 

for current month directly use 
sales = sum[Sales]



Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.