Compare Two Tables Using DAX | Power BI Case Study

Рет қаралды 13,170

4 ай бұрын

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.
Dealing with Incorrect Totals in Power BI - • Dealing with Incorrect...
Download the File ⬇️ - goodly.co.in/compare-two-tabl...
===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨‍🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
Download File ⬇️ - goodly.co.in/compare-two-tabl...
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - goodly.wordpress@gmail.com
===== 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!

Пікірлер: 36

@GoodlyChandeep 4 ай бұрын

Dealing with Incorrect Totals in Power BI - kzfaq.info/get/bejne/r91ghKumnryYhYU.htmlsi=ao_f-ZEoJ-yr_7hG Download the File ⬇ - goodly.co.in/compare-two-table-using-dax Also check out my courses on DAX & Data Modeling- rb.gy/gsj3rw

@DataAnalyticsFinance 4 ай бұрын

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

@juja2819 4 ай бұрын

I totaly agree on this!

@GoodlyChandeep 4 ай бұрын

Thank you. We need more people like you 😀😉

@randomguy-jo1vq 4 ай бұрын

I strongly agree

@joaorataoo 4 ай бұрын

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!! 😄😄😄😄😄😄

@kristinajensen711 4 ай бұрын

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.

@bravucod 4 ай бұрын

100% agree!

@radon8452 4 ай бұрын

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

@mrshrkbt 4 ай бұрын

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

@bradj229 4 ай бұрын

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!

@carloserodriguez2465 4 ай бұрын

thanks for this awesome tutorial!!!!! You are AMAZING!!

@Ratnakumarwrites 4 ай бұрын

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

@prajapatirp 4 ай бұрын

Amazing Chandeep. Superb!!

@swapnilpatil3329 4 ай бұрын

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

@muhammadtambawala6379 4 ай бұрын

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))

@chrism9037 4 ай бұрын

Awesome Chandeep!!!

@user-tp3jq8qg8l 4 ай бұрын

absolutely amazing..

@emilat_laccd630 2 ай бұрын

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

@gayatrilshinde1560 3 ай бұрын

Wonderful 💯

@ridohconcepts8868 4 ай бұрын

Awesome!

@Ifudjdjdkdjfjdjdj Ай бұрын

Wow, great video

@patrickharilantoraherinjat2994 4 ай бұрын

Just awesome

@trustnoone6065 4 ай бұрын

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

@gennarocimmino 4 ай бұрын

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?

@mohammadaliheidary2096 4 ай бұрын

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

@odekunleodebiyiomotayo6690 4 ай бұрын

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

@shubhabratadey 4 ай бұрын

You are WEIRDLY GENIUS...😄

@GoodlyChandeep 4 ай бұрын

I like the genius part but why weird 😂?

@viveks4 4 ай бұрын

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.

@karimessam6719 14 күн бұрын

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🙏🙏

@nikakalichava8012 4 ай бұрын

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?

@GoodlyChandeep 4 ай бұрын

www.microsoft.com/en-us/download/details.aspx?id=58494

@nikakalichava8012 4 ай бұрын

@@GoodlyChandeep Thanks a lot! Goodly, do You have videos on how to fetch data from servers sql/oracle...?