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.
Hi, I have a pivot table with my products(columns) and some periods(rows), its market share for this month and I want another column with market share(values) but from same period of last year. I tried many things but no way.
My market share function is:
Solved! Go to Solution.
Hi @Anonymous ,
Please check my example attached.
Use "Year" column from Dates table not financials table in my example.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I'll second @Icey's solution. This would be the easiest way to get to your required goal of showing the previous period market share.
Hi @Anonymous ,
How about this?
Create a Dates table and create relationship between your fact table and Dates table. Then, create [MS LY] measure like so:
MS LY =
CALCULATE (
[MS],
FILTER ( ALL ( Dates ), Dates[Year] = MAX ( Dates[Year] ) - 1 ),
SAMEPERIODLASTYEAR ( Dates[Date] )
)
If this does not work, please share me some sample data for test.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Icey ,
I created the 'Dates' table.
This is what I want to see:
And this are my formulas:
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |