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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Malinpetersson
Regular Visitor

Need Help

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

1 ACCEPTED SOLUTION
tex628
Community Champion
Community Champion

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


Connect on LinkedIn

View solution in original post

2 REPLIES 2
tex628
Community Champion
Community Champion

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


Connect on LinkedIn

Thanks, Ill start whit that.

 

/Malin

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.