5 Super Helpful DAX Tricks!
Вставка
- Опубліковано 10 вер 2024
- In this video, we will learn about 5 awesome DAX tricks that will help you save time and improve your Power BI reports.
We will cover how to apply reverse filtering in your data models, fix totals in Power BI, smartly replace IF statements using MAX and MIN functions, avoid calculation spillovers, and identify and manage duplicate rows in a data model. These techniques are straightforward and practical, aimed at making your Power BI reports more accurate.
===== ONLINE COURSES =====
✔️ Master 'M' in Power Query -
goodly.co.in/l...
✔️ Mastering DAX in Power BI -
goodly.co.in/l...
✔️ Power Query Course-
goodly.co.in/l...
✔️ Master Excel Step-by-Step-
goodly.co.in/l...
✔️ Business Intelligence Dashboards-
goodly.co.in/l...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co....
Corporate Training 👨🏫 - www.goodly.co....
Need my help on a Project 💻- www.goodly.co....
Download File ⬇️ - goodly.co.in/5...
===== 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'll find a ton of interesting videos that I have created :) Cheers!
Download the Power BI File ⬇ - goodly.co.in/5-super-helpful-dax-tricks
Also, check out my courses on DAX & Data Modeling - goodly.co.in/learn-dax-powerbi/
I like your ‘Remove Spill Over’ solution! I’ve had this issue before, and my solution was to filter the calendar table back in Power Query. So, the future dates just don’t get loaded into the model. But your solution allows the future dates to remain in the model, which is good, in case you want to include projections or forecasts.
Thank you Chandeep for this Video, It's really helped me to explore or discover something that I don't know before.
Tip 2. Shoutout Greg Deckler for the fight.
Great video!
❤the best of every thing❤
I always enjoy your explanations. Thank you for these
Cool,Down the memory lane on previous video on 'Filter between Dimension Tables | CALCULATE function Trick!' for trick No 01.
BTW Goodly became Yellowish.But prefer white..
Thanks from South Africa!!!
For the Tip No 05 I suppose that includes Nested Iterations: Outer iteration sets the row context, while inner iteration (FILTER) scans and applies conditions.
hi goodly do you need thumbnail designer at cheap rates?
Thank you for this topic, really helpful and useful, excellent 🎉
Great video Chandeep!!
I solved problem #1 with this:
Unique Bands =
CALCULATE (
DISTINCTCOUNT ( Products[Band] ),
CROSSFILTER( Sales[Product ID], Products[Product Code], Both )
)
Which way would be better and why?
#2 It seems without ADDCOLUMNS it also works:
Max Region Sales =
SUMX(
SUMMARIZE (
'Calendar',
'Calendar'[Year],
'Calendar'[Month]
),
MAXX (
VALUES ( Sales[Region] ),
[Total Sales]
)
)
always helpful content..
The reverse filters trick is simply badass awesome 😅
Why not just use the calculate modifier : userelationship, bidirectional argument ? To force the filter back to the product dimension? The expanded table concept is a nice trick but could be very confusing to new users.
Thanks for the video! In tip 1, how do I display “-“ in place of blanks where data is no present? Relating my problem to this data model, I have a matrix visual with rows as products and bands as columns but let’s say a product can be in multiple bands. So, if I have 5 bands and 10 products where a product P1 is only present for 2 bands, I want to show “yes” in 2 columns and “No”/- in 3 columns.
Does the reverse filter start to become slow with millions of rows in the fact table?
Amazing ❤
🎉🎉🎉
Expanded table makes so much sense if you had SQL background
For tip 3, can I just use 0 instead of BLANK()?
I wish you would speak slower, but your class is good.
Concerning tip 1: I just saw a video from SQLBI (ua-cam.com/video/XSWXw-orvI4/v-deo.html) in which Alberto says to NEVER filter whole tables, only columns, exactly because of the expanded tables and the performance issues that can arise from them. In a small model like in the video, it might work fast, but if you have millions of rows perhaps not.
Too advanced for me!
Hindi wala course batao paji
Plz create video in hindi
Could you please give me solution,
I have two tables charges and payment my requirement is payment comes month on month based on charge bill month.
Suppose jan2024 charge billed $100 so $40 payment comes in jan2024 , $20 payment comes in feb2024, $15 comes in March 2024 and so on so. Bill ID is unique column in both table. How to calculate and show in matrix as
Row payment month
Charge . Jan24. Feb24 mar24
Jan2024. $40. $20. $15
Feb2024. $60. $25
Mar2024. $50
Please give me solution in pawar bi.
The fact that we should calculate right total every time is not awesome at all. It is awful. And what is the use of getting sum of maxs? It would be much better to get in total the biggest max if it is max calculation, or overall average if i calculate average.
Bane of Power BI : totals.
It's an example only.
Make in hindi
This was really difficult to understand
Why you doing youtube