The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
My data set has 6 months of data. I want to show 2 additional columns in the visualization:
1) the current month's percentage change from the previous month
2) The current month's % change vs 6 months ago
On the left is my input data, and on the right is the current visualization.
I have played with the MoM quick measure unsuccessfully. Note I do not want these "measures' for each month of the month's I am showing...I just want it for the most recent month.
Thanks as always!
Hi,
I don't think you can add 2 column only for the last month. Those 2 columns will have to be added for all the months.
Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.
User | Count |
---|---|
158 | |
109 | |
96 | |
83 | |
75 |
User | Count |
---|---|
154 | |
137 | |
131 | |
81 | |
62 |