Forum Discussion
Solved
Weighted Average
I have a dataset similar to this: Claim # DateSubmitted Date Paid # Of Days Between Date Submitted & DatePaid OR # Of Days Since Submitted 54321 3/1/2021 3/15/2021 14 54321 3/2/2...
Hey czuniga ,
the following measure should fulfil your criteria:
Average if not paid or 30 days = CALCULATE( AVERAGE( myTable[# Of Days Between Date Submitted & DatePaid OR # Of Days Since Submitted] ), FILTER( myTable, myTable[Date Paid] = BLANK() || DATEDIFF( myTable[Date Paid], TODAY(), DAY ) <= 30 ) )If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.bi
Hey czuniga ,
the following measure should fulfil your criteria:
Average if not paid or 30 days =
CALCULATE(
AVERAGE( myTable[# Of Days Between Date Submitted & DatePaid OR # Of Days Since Submitted] ),
FILTER(
myTable,
myTable[Date Paid] = BLANK() || DATEDIFF( myTable[Date Paid], TODAY(), DAY ) <= 30
)
)
If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
Best regards
Denis
Blog: WhatTheFact.bi
Worked perfectly. Thank you!
If I wanted to view this same information on a rolling basis, how could I do that?
I have this so far, but something is off:
Average if not paid or 30 days = CALCULATE( AVERAGE( Claims[Avg Days Outstanding] ), FILTER(ALLSELECTED(Claims ), Claims[DateService] <= max(Rolling_Calendar_Lookup[Date]) || DATEDIFF( Claims[PayDate], max(Rolling_Calendar_Lookup[Date]), DAY ) <= 30 ) )
