Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I am trying to create a measure that calculates the PRODUCT of the last 12 months. In the table below, column 1M = the current months values. Column 1Yr is my measure that is supposed to calculate the product of the prior 12 months values. As you can see, the 1Yr calculation seems to only result in the same value as 1M.
Here's my sample data.
Date | 1M | 1Yr |
9/30/2024 | 1.0154 | 1.0154 |
8/31/2024 | 1.0193 | 1.0193 |
7/31/2024 | 1.0266 | 1.0266 |
6/30/2024 | 1.0086 | 1.0086 |
5/31/2024 | 1.0233 | 1.0233 |
4/30/2024 | 0.9599 | 0.9599 |
3/31/2024 | 1.0155 | 1.0155 |
2/29/2024 | 0.9792 | 0.9792 |
1/31/2024 | 0.9948 | 0.9948 |
12/31/2023 | 1.0599 | 1.0599 |
11/30/2023 | 1.0864 | 1.0864 |
10/31/2023 | 0.967 | 0.967 |
9/30/2023 | 0.9533 | 0.9533 |
8/31/2023 | 0.9843 | 0.9843 |
7/31/2023 | 0.9969 | 0.9969 |
6/30/2023 | 1.0098 | 1.0098 |
5/31/2023 | 0.9755 | 0.9755 |
4/30/2023 | 1.0095 | 1.0095 |
3/31/2023 | 1.0359 | 1.0359 |
2/28/2023 | 0.9544 | 0.9544 |
1/31/2023 | 1.0634 | 1.0634 |
12/31/2022 | 0.9876 | 0.9876 |
11/30/2022 | 1.0887 | 1.0887 |
10/31/2022 | 0.97 | 0.97 |
And here's my (incorrect) measure:
Solved! Go to Solution.
I'm not sure what I was doing wrong, but that worked. Thanks!
User | Count |
---|---|
30 | |
27 | |
14 | |
13 | |
10 |