Forum Discussion

ekroll's avatar
ekroll
Frequent Visitor
4 years ago

Backlog by Location

Hi,  I'm still pretty new to Power BI, DAX and such and am trying to figure out how to create a backlog by location. I have 2 fact tables and a calendar table. I've linked both fact tables up to t...
ekroll's avatar
ekroll
Frequent Visitor
4 years ago

Yes, sorry, I was in the middle of adding some additional context when you replied to the first one.

So, I need to figure out cumulative backlog by store number, which is essentially:
(Any remaining pallets from previous day + 'Pallets Built'[PALLETS]) - 'Capacity'[Seasonal Capacity]

I've looked at the built in time functions and standard calendar related functions don't work for me as I need to use our company financial calendar and cannot rely on standard calendar dates aligning with our company's financial dates.

The 445_Calendar table I have in my model has all of the dates down to day-date that correspond to our company financial calendar.

 

SpartaBI's avatar
SpartaBI
Community Champion
4 years ago

ekroll they also have there patterns for fiscal calendars and custom calendars. Check them out and update

  • ekroll's avatar
    ekroll
    Frequent Visitor
    4 years ago

    I saw the custom time related calculations in there. I'll go throuh that and see if I can figure it out.

     

    Thanks.