Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
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]
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
103 | |
99 | |
98 | |
38 | |
37 |
User | Count |
---|---|
151 | |
121 | |
73 | |
71 | |
63 |