COMPARE "COLUMNS" IN MATRIX

[TI_Distrimed]

Boa tarde,Gostaria de saber se existe alguma forma de comparar colunas em um array para criar um filtro "diferente", estou tendo dificuldades porque na verdade essa coluna é uma linha.Exemplo (imagem): onde o valor do dia 05 ao diferente do dia 06, continua a aparecer na matriz.

 

[TI_Distrimed]

thank you so much! It worked ... sorry if I didn't explain it clearly.

[amitchandak]

@TI_Distrimed , I have not got it completely. In power bi, there is no diff between columns. So you have to create measures like this

This Day = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])))
Last Day = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])-1))
Last Day = CALCULATE(sum('order'[Qty]), previousday('Date'[Date]))

diff =[This Day] - [Last Day]

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.