dax formula to calculate this

[ianyyz]

I'm trying to make this formula or measure

(integrated metric minus yyz metric )/5 for each month

metric being revenue etc.

eg for November 21 revenue

(90,826 -14,448)/5 =15,276

then have the formula do that for the rest of the months

and metrics ...eg

December 21 revenue

(77,810 minus 12,708/5

etc

eventually going all the way down where the last

calculation would be for October 2022 cash

(34,324 minus 5,036(/5

sample data is here

https://docs.google.com/spreadsheets/d

[17z1VzIljrSmRdYtPYWgioGt5nz-lyhGC/edit?usp=

drivesdk&ouid=113270003913045553839&rtpof=true&

sd=true

[Anonymous]

Hi @ianyyz ,

I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized example data.

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu

[ianyyz]

trying something like this

Integrated Average (Exlcuding YYZ) = calculate(sumx('Integrated Merged',('Integrated Merged'[Value] -RELATED('YYZ Merged'[Value]))/5),'Integrated Merged'[Date]=related('YYZ Merged'[Date]),'Integrated Merged'[Metric]=related('YYZ Merged'[Metric]))


the problem is i think i cant find a 1 to many relationship to do this?