Comparing previous month value to next month on available months only

[NPK]

Hi

my data is as follows

i want to tshow the arrow marks depending on the available dates in the date column only. the dates are not continues. how can i create a measure to insert the arrow marks in the new column.

Thanks

[v-yuta-msft · Accepted solution]

Hi NPK,

You can use DAX formula like below:

Mark =

var preDate = CALCULATE(MAX(Table1[Date]), FILTER(ALL(Table1), Table1[Product Name] = EARLIER(Table1[Product Name]) && Table1[Date] < EARLIER(Table1[Date])))

var preResult = CALCULATE(MAX(Table1[Result]), FILTER(ALL(Table1), Table1[Product Name] = EARLIER(Table1[Product Name]) && Table1[Date] = preDate))

return

IF(preResult <> BLANK(), IF(Table1[Result] > preResult, UNICHAR(9650), UNICHAR(9660)))

You can refer to PBIX here:

https://www.dropbox.com/s/2n90rdatt9vgozv/For%20KingsleyZ.pbix?dl=0

Regards,

Jimmy Tao

[NPK]

Thanks Jimmy Tao, your soluton helped me to solve the problem.