Dealing with Incorrect Totals in Power BI - th-cam.com/video/yw0QHu9V4UQ/w-d-xo.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
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!! 😄😄😄😄😄😄
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.
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))
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!
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.😊
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?
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.
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?
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🙏🙏
Dealing with Incorrect Totals in Power BI - th-cam.com/video/yw0QHu9V4UQ/w-d-xo.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
I still don't understand why you only have 75k followers. You deserve atleast a million followers. Awesome content.
I totaly agree on this!
Thank you. We need more people like you 😀😉
I strongly agree
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!! 😄😄😄😄😄😄
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.
100% agree!
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))
You are so smart, brother. I enjoy watching your videos.
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!
Wow this is the best explanation I have ever seen of comparing tables in DAX - very clear. Thank you so much!
I'm so glad that this helped you!
Awesome video. Very clear and simple to follow. Thank you.
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.😊
Love your style of teaching boss.. as always...
thanks for this awesome tutorial!!!!! You are AMAZING!!
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
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?
Amazing Chandeep. Superb!!
Thanks Chandeep for this video. Is there a way to drill through the answer so we can see the actual IDs that changed
Thank you so much Chandeep!!! This is perfect content. I agree with @DataAnalyticsFinance 100%
Awesome as always❤. Thanks is a very small word.
Excellente, as usual!
Awesome Chandeep!!!
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.
absolutely amazing..
Wonderful 💯
Wow, great video
You are best in teaching . I would like to participate in your training but unfortunately I am from Iran and it is not possible
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?
www.microsoft.com/en-us/download/details.aspx?id=58494
@@GoodlyChandeep Thanks a lot! Goodly, do You have videos on how to fetch data from servers sql/oracle...?
Awesome!
Just awesome
You are good.
Hi sir, how can I join this channel?
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🙏🙏
You are WEIRDLY GENIUS...😄
I like the genius part but why weird 😂?
Goodly VDOs addicted here :D
too complicated for me- but thanks anyway!