Percentage change month and quarter

[veakin]

Hi,

I need help calculating the percentage change from the previous months and quarters.

I know of the two formulas previousmonths and previousquarter. However, I can't make it work...

I have five different numeric values, let's call them:

A, B, C, D, E

Then I have a Date_Snap_key, let's call it:

Date_1

Can anyone be of help regarding this issue. 

[veakin]

The dates are not only on monthly basis - they are daily... Also, I can´t call the month measure as it won't let me select the measure ´closing balance´...

[veakin]

Hi,
Just to give you an idea of what I have, I have provided a table below...
I have around 3000 rows, so I couldn't provide it all

Closing balance	Date
1400050	07 December 2020
5889910	20 December 2020
1588392	23 april 2021
1999993	09 November 2021

[v-rongtiep-msft]

Hi @veakin ,

Please have a try.

Create an index. Select Home >>Transform Data>>Add column>>Insex column>>From 1.

Then close and apply.

Create measures.

next_date = SUMX(FILTER(ALL('Table'),'Table'[Index]=SELECTEDVALUE('Table'[Index])-1),'Table'[Closing balance])

month = var diff = SELECTEDVALUE('Table'[Closing balance])-[next_date]
var month_=DIVIDE(diff,SELECTEDVALUE('Table'[Closing balance]))
return month_

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards

Community Support Team _ Polly

[v-rongtiep-msft]

Hi @veakin .

Please provide some data and desired output.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards

Community Support Team _ Polly

[veakin]

Yeah I have this column: 

This is what I have:

But my value columns is measures.. that's why its triggy...

[Anonymous]

---

I know of the two formulas previousmonths and previousquarter. However, I can't make it work...

---

Do you have a calendar table with "Mark as date table"  Built in time intelligence functions require that to function?  If you already have that done, can you share the DAX you are struggling with?