ฝัง
- เผยแพร่เมื่อ 14 พ.ย. 2023
- In this video, we're going to learn how to use Excel's SUMIF and COUNTIF functions in Power BI to analyse data.
DAX FILTER Function - • DAX FILTER Function
SUMX Function in DAX - • SUMX Function in DAX
===== 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/sumif-countif-po...
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepc. .
Email - [goodly.wordpress@gmail.com](mailto: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!
#powerbi #excelfunctions #dataanalysis #advancedanalytics #datainsights #powerbitutorial #ExcelIntegration #datavisualization - วิทยาศาสตร์และเทคโนโลยี
Download the File ⬇ - goodly.co.in/sumif-countif-power-bi/
This guy is insane... Following him from last year and every time he is ready to be surprised with his unique ideas and solutions ❤❤❤❤❤
Love it!!! Thank you!, From Vietnam
Chandeep, you are the best!!!
I am following many youtubers for Power BI and DAX, but not one gives multiple examples in one video which you do very flawlessly to clear out concepts. Kudos to you 👍
Sheesh - this is great! Especially love how you built up the fundamental logic to the running count example. Thanks!
Love every single video !!!!!!! You are so good. Thank you for sharing your knowledge ❤
Wow, this was great, thanks Chandeep!
Love it!!! ❤ Thank you!
Very nice... 🙏
The top 3 useful functions for any spreadsheet platform are lookup, countifs and sumifs.
By that criteria, this really was the best and most useful power bi podcast for me
I instantly saw the similarity to VBA loops
The VAR line is the equivalent of the start of the loop "for i = 1 to 100", for instance,
and the FILTER bit is the virtual table that the macro is running on.
This is my go-to method for sumifs and countifs in future.
Many thanks Goodly 😁
Excellent post🎉 @chandeep..
This is super helpful, i've been battling with a calculation for while. Trying to count the number customers based on last 12 mnths sales margin condition and grouped by a disconnected cohort table. Current, lost, at risk etc.
Thanks for your wonderful video. I never escape your videos without watching. Every video teaches new method and new steps. Recently I have mailed you my small problem to your email. I am still eagerly waiting for the solution.
Thanks
excellent
I learn a lot from you.
How to do = if(a1=a2,0,1) in dax on sorted column
Have you been able to generate an index sac function that would order the records in whatever order they are selected? For example, if I have several columns in a table, and I click on the heading of any of the columns to sort by that column, I want that index to recalculate and always show up as a “record counter” column (like, the first column in my table that would show how many records I have in total)
It’s easy to create an index in the default sort order, but it “breaks” as soon as you resort. So, my quest is to create that dynamic index no matter how you sort. And (it gets harder) if you have a slicer and select some specific data segment, that index column should still show up as 1, 2, 3, 4 etc for those selected records.
Hi Can i use same syntax as a measures in BI
Hi. I wanted to know if there is any way to join two or more tables based on inequality conditions in Power Query. I have a scenario in which a date column of one table should be between two date columns of another table. I am unable to perform merge operation based on this condition. I only know equal cases, but what about the inequalities like less than greater than between not equal etc. Please help me with this.
That is a really great recap video on how to do conditional counting and summing in DAX.
Great format! Keep up the good stuff.
Thanks a lot! :-)
Hi, I have one serious issue that am not able to tackle ..if you read this comment please give shot,
The problem goes like I have finance data where I have column for Gl account and it's monthly balance against it and there is 10 categories those Gl are divide ,so front end am calculating YTD,mtd and qtd but there is condition there 20 gl the have mapped under one of the category but they want switch the category on there sum like if those Gl sum positive then it should map to another category and if negative then another category..on every that should for qtd also if for qtd selected in front ent it should calculate there sum and the assign it ,Sam goes for YTD..plz help
@goodlychandeep how did you bring those slashes in one go please explain little bit in a descriptive way..
Ctrl /
Pls make tutorial how to merge query for example 1st query with 5 row and 2nd query with 8 row resulting a table with only 8 row but not 40 row. Thx
You overlooked EARLIER, COUNTROWS( FILTER( ALL(Table1),Table1[Item] = EARLIER(Table1[Item]) ))
also a theory question, if you just use Table[Col] = Table[Col] , no good but when
as you did you VAR = T= Table [Col] ; Table [Col] = T , you're good to go. I guess something to do with VAR being calculated once? Anyway great vid , keep up the fantastic work.
This was on purpose 😄
And yes you are right about VAR it is calculated once outside the iterator so when referenced it's value doesn't change.
EARLIER is a bad idea unless your table has very few rows... The performance cost is ridiculous!
@@HachiAdachi I'll keep that in mind, I always just think of EARLIER as go to function for a calculated column running total etc.
@@williamarthur4801The Italians are adamant that variables render EARLIER obsolete. They claim to include EARLIER in their books solely in the event you encounter it in a legacy project.
How is this achieved without ALL function in sales table inside FILTER function (timestamp : 4.19) ?
Try to reduce the speed the way you are speaking to understand
How to generate a column in PQ to record the alternatives(like order completed, order dispatched, order under progress etc) based on content conditions of various columns (say column dates).