topic COMPARE "COLUMNS" IN MATRIX in DAX Commands and Tips

COMPARE "COLUMNS" IN MATRIX

TI_Distrimed — Thu, 25 Feb 2021 18:22:02 GMT

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.

Re: COMPARE "COLUMNS" IN MATRIX

amitchandak — Fri, 26 Feb 2021 05:43:10 GMT

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.

Re: COMPARE "COLUMNS" IN MATRIX

TI_Distrimed — Fri, 26 Feb 2021 17:57:21 GMT

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