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