Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
103 | |
90 | |
78 | |
72 | |
68 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |