End-to-End DAX Tutorial | Power Bi | SUM-SUMX-CALANDAR-FIRSTDATE - LASTDATE | KSR Datavizon
Vložit
- čas přidán 27. 04. 2023
- github.com/ksrpowerbi/KSR_DAX...
Power BI is a powerful data visualization and business intelligence tool developed by Microsoft. It uses a formula language called Data Analysis Expressions (DAX) for creating custom calculations, aggregations, and measures in Power BI reports and dashboards. Here are some commonly used DAX functions in Power BI:
SUM: Calculates the sum of a column.
AVERAGE: Calculates the average of a column.
COUNT: Counts the number of rows in a column.
MIN: Returns the minimum value in a column.
MAX: Returns the maximum value in a column.
CALCULATE: Modifies the context in which a calculation is performed.
FILTER: Applies filters to a table, returning the filtered table.
RELATED: Follows a relationship to retrieve a value from a related table.
DISTINCT: Returns a one-column table that contains the unique values from a column.
DATEADD: Returns a new date value by adding a specified number of intervals to a specified date.
These are just a few examples of the many DAX functions available in Power BI. DAX offers a wide range of functions for data manipulation, aggregation, filtering, time intelligence, and more, allowing you to create complex calculations and analysis in your Power BI reports.
4:47 SUMX Function
10:00 SUM Function
14:00 FIRSTDATE Function
15:30 LASTDATE Function
17:00 CALANDERAUTO Function
19:00 CALANDER Function
25:30 CALCULATE & PREVIOUSYEAR Function
31:00 DIVIDE Function for Year
34:30 CALCULATE & PREVIOUSMONTH Function
37:30 DIVIDE Function for Month
39:30 CALCULATE & PREVIOUSQUARTER Function
42:40 CALCULATE & PREVIOUSDAY Function
45:00 CALCULATE & NEXTDAY,QUARTER, MONTH and YEAR Function
How are we different from Others...?
1. 24*7 Recorded sessions Access & Support
2. Flexible Class Schedule
3. 100 % Job Guarantee & 100 % Live Training
4. Mentors with +14 yrs. & Free Microsoft License
6. LMS And APP Availability for a Good live session experience.
7. Soft Skills I Email Etiquette I Client/Stakeholders Handling Techniques.
Call us on IND: 9916961234 / 8527506810 to talk to our Course Advisors
👉Please ping on WhatsApp: - wa.me/918951796123
#DAX #DataAnalysis #DataVisualization
#PowerBI
#DataModeling
#DataAnalysis
#DataVisualization
#BusinessIntelligence
#Measure
#CalculatedColumn
#DataAnalytics
#DataModel
You did better than everyone else. You really want to educate people. Really nice explanation.
Well articulation., Uma. This is how a tutor needs to deliver.
Thank you, Please subscribe our channel for regular updates , it motivate us
This is great! Organized so well. Thank you.
awesome session
Thanks , very helpful !
U r doing very nice work..
Nice Video
Thank you .
Thank you
Nice!!!!!!
Hi @KSR Datavizon - At 17:59, you have created calendar with calendarauto. There is only one "Date" datatype column, so it has considered it and created the calendar. If there is more than one "Date" datatype column, which one it will consider?
hiii good morning mam vry use full vedio thank u mam
Thank You Ravi.!
How did you join Measures_TB table to Bikes table?
Whenever I am using shapes, the image or the text box or any other shape which I am trying to add on top of it disappears. Can you please help me in this regard? I'm using the latest release.
Sir, How we can do the function similar to Indirect function in Excel, in power BI. For Ex. I am having a slicer with the name of all Indian states, If I don't select any thing from slicer, then in the table for ROW value , name of state should come and their population. If I select any state from slicer , then in the table, respective district list should appear and there population.
Please make more videos on DAX and Data Modelling
czcams.com/video/VttUwZfJwJw/video.html
Thank you. Please provide the data set in the description
github.com/ksrpowerbi/KSR_DAX_Datasets
Thank you.
Please provide the dataset link in the description.Thank you.
github.com/ksrpowerbi/KSR_DAX_Datasets
Calendar function will return a date , which is first date in data modelling not a fiscal year
We can create table or even addition column with fiscal year details also
Hi Mam ,From where we can this excel as a data source ,Can you please provide this ?
All dataset links is attached in discrpitiom
mam sat was i have an one interview on power bi they ask 1) calculate(countrows(sales),[totalsales]>500) is work or not .. the answer is not work but something is mistake mam how we will write this query and 2) if(HASONEVALUE(sales[country]),values(sales[country])) they ask u write another format i was very confused mam i can not understand the func please give me currect answer ....its help full for another interviews
We will provide you the Answer here Soon Ravi.!
The formula calculate(countrows(sales),[totalsales]>500) is not syntactically correct in Power BI.
To achieve this, you can use the following DAX formula in Power BI:
CALCULATE(COUNTROWS('Table'),'Table'[Sales]>500)
IF(HASONEVALUE(sales[country]), VALUES(sales[country]), BLANK())
&
CALCULATE(COUNTROWS(sales), sales[totalsales] > 500)
Answer to your 2nd Question : IF(HASONEVALUE(sales[country]), SELECTEDVALUE(sales[country]))
&
IF(HASONEVALUE(sales[country]), VALUES(sales[country]), BLANK())
In which company u have attended mam and through which source(LinkedIn or naukri)
mam i was attend kadel labs from bangulore location i was receiving mail throuh noukri
Please provide sql queries questions for power bi interview
czcams.com/video/29jJy4tAOPE/video.html
czcams.com/video/kxPLm_Y4udQ/video.html
czcams.com/video/VAOpMH_iXMA/video.html
Hi Khushboo, Hope the below videos will help you with SQL Quarries Questions
Please share dataset
github.com/ksrpowerbi/KSR_DAX_Datasets
Hello Madam can i get job as power bi fresher
Call us on 8951796123 for more details
Please tell about the use of concatenate x also