Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I want to accumulete sales values. My year starts 1 of september. Would be nice if I also coudl see which period its is. E.G from 01-09-2018-- 30-06-2019.
Thanks in advanced!
Br,
Malin
Solved! Go to Solution.
Hello @Malinpetersson ,
I would start by classifying each sales year in your calendar table.
A calculated column like this should do the trick.
Column = VAR minYear = IF([Month] > 8 , [Year] , [Year] -1 ) VAR maxYear = IF([Month] < 7 , [Year] , [Year] +1 ) Return
IF([Month]=7 || [Month]=8 , BLANK() , "01-09-" & minYear & " - 30-06-" & maxYear )
Then use this column to filter your sales and you should get the correct amounts i believe.
/ J
Hello @Malinpetersson ,
I would start by classifying each sales year in your calendar table.
A calculated column like this should do the trick.
Column = VAR minYear = IF([Month] > 8 , [Year] , [Year] -1 ) VAR maxYear = IF([Month] < 7 , [Year] , [Year] +1 ) Return
IF([Month]=7 || [Month]=8 , BLANK() , "01-09-" & minYear & " - 30-06-" & maxYear )
Then use this column to filter your sales and you should get the correct amounts i believe.
/ J
Thanks, Ill start whit that.
/Malin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |