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.
Hello.
I have a table of historical data for the past couple of fiscal years. I am trying to divide one column [Obs], by the value on the last month of the year in a different column [Ann].
I tried the following:
The Table looks like this:
I am trying to DIVIDE the green [Obs] by the green [Ann] for each month. And Divide the red [Obs] by the red [Ann] for each month. Here, in yellow, is what I am looking for:
Here it is again in order by date so you can see the percantage increase each month:
Thanks.
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
Do you want a calculated column or a measure solution? Share your MS Excel file with your formula so that i can translate that into the DAX language.
A measure would likely be better. It is to put into a line graph showing the % by the month. The below is not correct, the % Diff should be 0-100% and the months on the X axis will show by month, not number:
Here is the sample file link:
https://drive.google.com/file/d/1p_Z6UziWgvyYF_iAaQziI_8Ymv2Rbo2Z/view?usp=sharing
Thanks
Hi,
Please clarify the following:
Is my understanding correct?
Correct. The Fiscal Year Starts in October and Ends in September. So Fiscal Year 2020 Started on October 1, 2019 and ended Sepember 30, 2020.
Hi,
You may download my PBI file from here.
Hope this helps.
Thank you very much. This has taken me days.
You are welcome.
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |