Calculation on last value date,

[Sachy123]

SO I have data in the following format

Date	Ticker	Price
2020-11-30	X	20
2020-11-30	Y	5
2020-11-30	Z	2
2020-11-30	A	100
2020-10-30	X	10
2020-10-30	Y	15
2020-10-30	Z	20
2020-10-30	A	10

So I make a matrix view in my report and I see the following

Date	X	Y	Z	A
2020-11-30	20	5	2	100
2020-10-30	10	15	20	10

Now I am trying hard to write a measure Perc_Change, that if dragged in the matrix view, should give me the percentage change from 

2020-10-30 to 2020-11-30 for that Asset.

Date	X	Perc_Change	Y	Perc_Change	Z	Perc_Change	A	Perc_Change
2020-11-30	20	100%	5	-66%	2	(2-20)/20	100	(100-10)/10
2020-10-30	10	0%	15	0%	20	0%	10	0%

Or is it better to do it in a Query view?

[amitchandak]

@Sachy123 , This month vs Last month for that with help of time intelligence and date table

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last month Sales = CALCULATE(SUM(Sales[Sales Amount]),previousmonth('Date'[Date]))
this month =MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH('Date'[Date])))
last MTD (complete) Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH(dateadd('Date'[Date],-1,MONTH))))
previous month value = CALCULATE(sum('Table'[total hours value]),previousmonth('Date'[Date]))

diff = [MTD Sales]-[last MTD Sales]
diff % = divide([MTD Sales]-[last MTD Sales],[last MTD Sales])

[Sachy123]

THANK YOU!

[littlemojopuppy · Accepted solution]

Good morning!

Here's a couple measures...

Current Price:=AVERAGE(Tickers[Price])

Previous Price:=CALCULATE(
		[Current Price],
		PREVIOUSMONTH('Calendar'[Date])
	)

Price MTM Change:=[Current Price] - [Previous Price]

Price MTM % Change:=DIVIDE(
		[Price MTM Change],
		[Previous Price],
		BLANK()
	)

Using AVERAGE() because I'm not sure if you'll have more than one price in any given month.  If you do, you might want to change that to MIN(), MAX() or whatever suits your needs.

Results

[littlemojopuppy]

Forgot to mention...you'll have to have a date table because of the time intelligence function for this to work correctly.