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 everyone,
I'm needing help from some mind higher than mine to do the following.
I have the following table of percentage inflation values month by month.
I need to make a measure that allows me to calculate the cumulative inflation of 12 months but not those of the last month but of two previous years:
I have resolved the cumulative inflation of 12 months back from the selected date of the slicer on the left but I want that of the previous 12 months.
With the following measure create the cumulative inflation of the last 12 months of the selected date in the slicer.
Thanks for the help!!!
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
You are welcome. If my reply helped, please mark it as Answer.
You are welcome. You can download my PBI file from here.
I hope this helps.
Hi,
Share the link from where i can download your MS Excel file with your formulas so that your calculation logic can be understood. Also, on another tab in the workbook, please show the expected result in a simple table format.
Thanks Ashish !!! You are the best my friend.
Here attached the link to download with the . PBIX file and inside it the created measures and the source I'm working.
https://drive.google.com/file/d/15IGuOfcaRCL6bvdU2mv_N4WGMhZVuj9n/view?usp=sharing
@Ashish_Mathur wrote:Hello
Share the link from where I can download your MS Excel file with your formulas so you can understand your calculation logic. Also, on another tab of the workbook, display the expected result in a simple table format.
@Ashish_Mathur wrote:Hello
Share the link from where I can download your MS Excel file with your formulas so you can understand your calculation logic. Also, on another tab of the workbook, display the expected result in a simple table format.
Hi,
That is not what i asked you for in my previous post. Please read my previous post carefully.
Sorry....
Sorry, you're right... Below the link with the Excel with the calculation formulas and all the information.
https://drive.google.com/file/d/1pIDW00J5LqlMsPuXoqAL8T8zG7iOCIGV/view?usp=sharing
Thanks
Hi,
You may download my PBI file from here.
Hope this helps.
Thanks !!! You are the best.
You are welcome. If my reply helped, please mark it as Answer.
Sorry Ashish,
If I need to recalculate this measure in function of the date selected in the slicer? For example 2020-Jan.
Thanks.
Hi,
I do not understand your requirement. Clearly show the selection you would be making and show the percentage you are expecting as a result of that selection.
Thanks again Ashish...
I really appreciate and value your help.
I put another version of the excel with the requirement. The Value need to change in function of the value selected in the slicer. More details in the excel (with examples)
https://drive.google.com/file/d/1FELxg8x1mulFMHkJy8I83hhADl3ETKog/view?usp=sharing
Thanks.
You are welcome. You can download my PBI file from here.
I hope this helps.
Eternal gratitude!
Seriously you are the best my friend!!! Thanks....
You are welcome. Thank you for your kind words.
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 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |