Forum Discussion

Sachy123's avatar
Sachy123
Icon for Helper V rankHelper V
5 years ago
Solved

Calculation on last value date,

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-...
Need Help
Show and Tell
  • littlemojopuppy's avatar
    littlemojopuppy
    5 years ago

    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

     

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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's avatar
    Sachy123
    Icon for Helper V rankHelper V
    5 years ago

    THANK YOU!