Filter : day minus 7

[Green_Boby]

Good morning,

I am trying to calculate the Technical_dispatch_reliability of the same day of last week (ie minus 7 days). I thought the screenshot below would do the job but it does not: there is a calculation but I don't get the same result manually. Please note that as this is a dynamically connected file, I cannot create new colums in my table, I can only use measures.

Technical_dispatch_reliability : data to be calculated from rough data

STD_DATE : Column containing dates of some rough data

Is my fomula correct?

Best regards,

[v-yuta-msft]

Hi Green_Boby,

Modify your measure as below and check if it can meet your requirement:

Technical_dispatch_reliability_15_TO_D-7 =
CALCULATE (
    Technical_dispatch_reliability_15_TO,
    FILTER ( OPS_LEG, OPS_LEG[STD_DATE] = TODAY () - 7 )
)

Regards,

Jimmy Tao

[Green_Boby · Accepted solution]

Hello,

I found out why my calculation was wrong: nothing to do with my filter actually. Be advised, the one I'm using works fine, but yours is not: as this is a connected table, I cannot use the DATEADD.

Thank you for you help anyway!

Best regards,

[Stachu]

try this

Measure = CALCULATE([Technical_dispatch_reliability_15_TO];DATEADD('OPS_LEG'[STD_DATE];-7;DAY)