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.
Go to Solution.
You can use DAX formula like below:
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))
IF(preResult <> BLANK(), IF(Table1[Result] > preResult, UNICHAR(9650), UNICHAR(9660)))
You can refer to PBIX here:
Thanks Jimmy Tao, your soluton helped me to solve the problem.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.