Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
TI_Distrimed
Advocate I
Advocate I

COMPARE "COLUMNS" IN MATRIX

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.

ren6gQO.jpg

2 REPLIES 2
TI_Distrimed
Advocate I
Advocate I

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

amitchandak
Super User
Super User

@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.

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.