Help with Formula DAX

[Anonymous]

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.

Acum inflation. 12 months - CALCULATE(PRODUCTX('Inflation','Inflation'[Inflation]),DATESINPERIOD(Calendar[Date],LASTDATE(Calendar[Date]), -12,MONTH))-1

The other measure that I can't generate well is the one that gives 124.04% that brings me the accumulator of the 24 months but I want you to bring the first 12 months and be mobile from the date you select in the slicer. This measure I have to correct.

Acum inflation. 24 Months Ant. ? CALCULATE(PRODUCTX('Inflation','Inflation'[Inflation]),DATESINPERIOD(Calendar[Date],LASTDATE(Calendar[Date]), -24,MONTH))-1

Thanks for the help!!!

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[Ashish_Mathur · Accepted solution]

You are welcome.  If my reply helped, please mark it as Answer.

[Ashish_Mathur]

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.

[Anonymous]

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.

---

[Ashish_Mathur]

Hi,

That is not what i asked you for in my previous post.  Please read my previous post carefully.

[Anonymous]

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

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[Anonymous]

Thanks !!! You are the best.

[Ashish_Mathur · Accepted solution]

You are welcome.  If my reply helped, please mark it as Answer.

[Anonymous]

Sorry Ashish,

If I need to recalculate this measure in function of the date selected in the slicer? For example 2020-Jan.

Thanks.

[Ashish_Mathur]

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.

[Anonymous]

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.

[Ashish_Mathur · Accepted solution]

You are welcome. You can download my PBI file from here.

I hope this helps.

[Anonymous]

Eternal gratitude!

Seriously you are the best my friend!!! Thanks....

[Ashish_Mathur]

You are welcome.  Thank you for your kind words.