Outstanding amount for the last 15 weeks

[LotteLaugesen]

Hi

I need to calculate the outstanding amount for each week in the last 15 weeks. 

The amount is outstanding if entry date <= last day of week and paid date > last day of week.

Can anybody help to write that in DAX? 

Lotte 😊

[amitchandak]

@LotteLaugesen , You can get start/ end of week like this

//Monday start week

Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1
Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],2)

//Sunday start week

Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],1)+1
Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],1)

you can use these days in creation of new column

[LotteLaugesen]

Thank you, but I was hoping that I could use somthing like this:

Outstanding =

CALCULATE(

SUM('Table'[Amount]),

DATESBETWEEN('Calendar'[Date], 'Table'[Entry Date], Table[Paid Date]))

And when use it in a matrix together with weeks

As you can see - I'm a newbie in DAX and Power BI 😂