Forum Discussion

sdhn's avatar
sdhn
Responsive Resident
2 years ago

Calculate Annual Growth Rates

Hello All,   I am comparing two Fiscal period. On my situation  FY1  July 1 , 2023 to December 31 2023 FY2  Jan 1, 2024 to June 30 2024    Inm y Power bi report , I am showing data for both fi...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi sdhn ,

Please create a measure as below to get it:

Annual Growth Rate = 
VAR _fy1 =
    COUNT ( 'TD_IncBreach1FY'[Incident ID] )
VAR _fy2 =
    COUNT ( 'TD_IncBreach2FY'[Incident ID] )
RETURN
    ( _fy2 / _fy1 ) - 1

Best Regards

  • sdhn's avatar
    sdhn
    Responsive Resident
    2 years ago

    Thanks, this is good too.

    But I need for Breaches only on monthly basis.  Can you assist on it?  Thanks