Forum Discussion
Compare monthly average vs Total Average
- 2 years ago
Hi romovaro ,
Based on the sample and description you provided, Please try code as below.
My Sample:Total Average = VAR _Day = SUM ( 'LOA assignations'[LOA Sig date vs greenlight date] ) VAR CNT = COUNTROWS ( 'LOA assignations' ) RETURN _Day / CNTLOA Month Comp = AVERAGE ( 'LOA assignations'[LOA Sig date vs greenlight date] ) - SELECTEDVALUE ( 'LOA assignations'[Total Average] )Result is as below.
If this reply still couldn't help resolve your issue, please feel free to ask us. Please share more details or share a sample pbix after removing sensitive data with us.
Best Regards,
Yulia Yan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi romovaro ,
Based on the sample and description you provided, Please try code as below.
My Sample:
Total Average =
VAR _Day =
SUM ( 'LOA assignations'[LOA Sig date vs greenlight date] )
VAR CNT =
COUNTROWS ( 'LOA assignations' )
RETURN
_Day / CNT
LOA Month Comp =
AVERAGE ( 'LOA assignations'[LOA Sig date vs greenlight date] )
- SELECTEDVALUE ( 'LOA assignations'[Total Average] )
Result is as below.
If this reply still couldn't help resolve your issue, please feel free to ask us. Please share more details or share a sample pbix after removing sensitive data with us.
Best Regards,
Yulia Yan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.