Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have Data table called Base data . sample data pasted the below .i am trying to find Compound annual growth rate for year wise and quarter Wise .in Excel i have used the below formula
if i clus
=(Currentyear/Previousyear) ^ (1/Number of Years) - 1.
Year wise if i select Year difference 1 its should compare 2022 vs 2021
Quarter wise if i select Q1 value should compare 2022 Q1 vs @2021 Q1
Month wise if i select January value should compare 2022 Jan vs @2021 Jan
Sample data
Date Value Region
01-01-2021 234 East
01-02-2021 243 South
01-03-2021 123 West
01-04-2021 452 East
01-05-2021 132 South
01-06-2021 456 North
01-07-2021 874 North
01-08-2021 234 South
01-09-2021 764 West
01-10-2021 234 South
01-11-2021 334 South
01-12-2021 764 South
01-01-2022 234 South
01-02-2022 764 West
01-03-2022 234 North
01-04-2022 764 East
01-05-2022 23 North
01-06-2022 567 South
01-07-2022 453 South
01-08-2022 345 west
01-09-2022 453 west
01-10-2022 344 North
01-11-2022 342 North
01-12-2022 432 South
Looking for support .. thanks in advance ...
Please explain what you mean by "Number of Years".
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
53 | |
46 | |
15 | |
12 |