Compare Two Tables Using DAX | Power BI Case Study

Compare Two Tables Using DAX in Power BI |/ A DAX Case Study

In this video, we'll tackle a tricky DAX problem on how to compare tables in Power BI. I'll walk you through the logic and steps to solve it. Tune in to boost your Power BI and DAX skills.

===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

===== LINKS 🔗 =====

===== CONTACT 🌐 =====

===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!

[RituAgarwalOfficial]

I still don't understand why you only have 75k followers. You deserve atleast a million followers. Awesome content.

[joaorataoo]

I have to make a confession:
I've been your videos and explanations for a while now and feeling of love/hate increases every time I watch a new video.
It's incredible how easy and clear your explanations are, making everything seem so simple!!!... and the simpler they seem, the dumber I feel!
Keep going, I don't mind!! 😄😄😄😄😄😄

[kristinajensen]

Hej Chandeep, half way through the video, and I absolutely LOVE your approach, explanation and method of explaining the concept so anyone can follow. Please keep making videos in this fashion, DAX is not the easiest of languages.

[radon]

You are so smart, brother. I enjoy watching your videos.

[CDSPIKMcLorg]

Wow this is the best explanation I have ever seen of comparing tables in DAX - very clear. Thank you so much!

[mrshrkbt]

Awesome video. Very clear and simple to follow. Thank you.

[bradj]

Hi Chandeep. I've purchased both of your courses (DAX & Power Query) and THIS type of in depth DAX video is what am interested in the most. I hope you make a similar "advanced DAX" course in the future. Thanks for sharing!

[muhammadtambawala]

Great job, Chandeep! Your videos are a continual source of learning for me. An Excel-based solution could involve using the following formula. Enter it in "Sheet1" cell H1 and proceed with a standard pivot to sum the upgrades by months.
=LET(
EP, C2:C587&"|"&F2:F587,
EOM, MAP(A2:A587, LAMBDA(a, EOMONTH(a, 0))),
LMV, IFERROR(INDEX(E2:E587, MATCH(EP&EOMONTH(EOM, -1), EP&EOM, 0)), ""),
C, MAP(LMV, E2:E587, LAMBDA(a, b, AND(a="Base Version", b="Professional Version"))),
VSTACK({"Month-Year", "Upgrades"}, FILTER(HSTACK(EOM, C), CHOOSECOLS(HSTACK(EOM, C), 2)=TRUE)*1))

[Ratnakumarwrites]

Love your style of teaching boss.. as always...

[carloserodriguez]

thanks for this awesome You are AMAZING!!

[swapnilpatil]

You are amazing man!👏 Your approach to solving the problem is awesome. The way you explain the solution is amazing. Loved to watch every video. Thank you for making the DAX easy.😊

[trustnoone]

Awesome as always❤. Thanks is a very small word.

[Maanikmm]

Can we select the parameters from a slicer to choose base version and product version or anything else to compare? Or it’s needs to be hardcoded

[gennarocimmino]

you really are a good one!
Thank you for sharing this tutorial

I saw that the Total at the bottom also appears with a variant to your size.
Measure Test =
SUMX(
VALUES(Cal[Month-Year]),
[Upgrades]
)
Contraindications?

[emilat_laccd]

Thank you so much Chandeep!!! This is perfect content. I agree with @DataAnalyticsFinance 100%

[odekunleodebiyiomotayo]

Thanks Chandeep for this video. Is there a way to drill through the answer so we can see the actual IDs that changed

[viveks]

Hello chandeep, I have a question on Running total for dates and non dates,
You used max for calendar date but you didn't use it for Rankx function on running total Video, Could you please clear this point.

[mohammadaliheidary]

You are best in teaching . I would like to participate in your training but unfortunately I am from Iran and it is not possible

[nikakalichava]

AMAZING!
Goodly, I can not open a file, it says i need a newer version but when I go to Microsoft Store to download it does not have an update... just save... Any other suggestions on where to download newer versions?

[karimessam]

i want to compare two virtual tables but not all the names,
I want to compare bottom5 in day with bottom 5 in previous day.
and return names from previous day not in selectedday.

you returned count of rows, I want to return names.
also I want to create 2 virtual tables in var and it contains name, sales and then compare names from these 2 var.

i stucked into it for a week.
can anyone help me plz🙏🙏