mm-yyyy

[Anonymous]

Hi,

I have data as mentioned below table.

S.No	Month-year	Value
1	12-2019	3
2	11-2019	5
3	10-2019	2
4	01-2019	6
5	12-2018	7
6	11-2018	1

Requiremnt  is, if i select month (12-2019) here  i need to display previous month and selected month difference( selected month - previous month) .  can you please help me on this.

Thanks !

Regards,

Srini.

[harshnathani]

Hi @Anonymous ,

Create a Column

Column = 
'Table'[Value] - MAXX(FILTER('Table', 'Table'[S.No]< EARLIER('Table'[S.No])), 'Table'[Value])

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Anonymous]

Hi @harshnathani ,

thank you for your response. but i dont have the date column. i have the month-year formate(mm-yyyy) and this is custome column as text format. please suggest me the approach.

Regards,

Srinivas.

[harshnathani]

Hi @Anonymous ,

You have the Index Number. Make sure are descending in nature from the earliest month in text format.

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Anonymous]

Hi,

is it possible with out index number, reason is i need to display the value month wise  in  bar chart.

Regards,

Srini

[harshnathani]

HI @Anonymous ,

You will need an index column to refer earlier dates.

Also since your date column is also text , this wil also not help.

See if this helps you

https://community.powerbi.com/t5/Community-Blog/Getting-Previous-Values-in-Power-BI-Part-1/ba-p/1143370

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)