End-to-End DAX Tutorial | Power Bi | SUM-SUMX-CALANDAR-FIRSTDATE - LASTDATE | KSR Datavizon

[@ekjibon]

You did better than everyone else. You really want to educate people. Really nice explanation.

[@4nxh___]

Well articulation., Uma. This is how a tutor needs to deliver.

[@KSRDatavizon]

Thank you, Please subscribe our channel for regular updates , it motivate us

[@elisahorton4833]

This is great! Organized so well. Thank you.

[@subhashiniravi-r1s]

hiii good morning mam vry use full vedio thank u mam

[@KSRDatavizon]

Thank You Ravi.!

[@Bantikumar-c2n]

awesome session

[@nimikajadav3004]

U r doing very nice work..

[@PowerBIDumps]

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?

[@KSRDatavizon]

When using CALENDAR or CALENDARAUTO in Power BI, if there are multiple date columns in your dataset, the function will only consider the first date column it encounters based on the query's order. To explicitly define which date column to use for your calendar, it’s best to create a separate calculated table using the CALENDAR function with the specific date column as an argument. This way, you can ensure that the desired date column is used for your calendar. If you have any other questions, feel free to ask!

[@sivajigade5053]

Thank you. Please provide the data set in the description

[@KSRDatavizon]

github.com/ksrpowerbi/KSR_DAX_Datasets

[@sivajigade5053]

Thank you.

[@JAYANTKUMAR-ok6ns]

How did you join Measures_TB table to Bikes table?

[@Ankit-vo1pm]

Thanks , very helpful !

[@akhil4000]

Please provide the dataset link in the description.Thank you.

[@KSRDatavizon]

github.com/ksrpowerbi/KSR_DAX_Datasets

[@deepamishra5832]

Hi Mam ,From where we can this excel as a data source ,Can you please provide this ?

[@KSRDatavizon]

All dataset links is attached in discrpitiom

[@madhavyedle4944]

Please make more videos on DAX and Data Modelling

[@KSRDatavizon]

kzbin.info/www/bejne/jKXXhqqQm6-qgNk

[@lakshminarayana3168]

Calendar function will return a date , which is first date in data modelling not a fiscal year

[@KSRDatavizon]

We can create table or even addition column with fiscal year details also

[@krishnaRaog21]

Nice Video

[@KSRDatavizon]

Thanks for the visit, Please subscribe our channel for regular updates.

[@Nashu-babe]

Please tell about the use of concatenate x also

[@KSRDatavizon]

sure

[@aishwaryapattnaik3082]

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.

[@KSRDatavizon]

After doing charts.. lock the objects

[@RavinderKumar-gl8cy]

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.

[@KSRDatavizon]

In Power BI, we don't have a direct equivalent of the INDIRECT function from Excel, but you can achieve this behavior using DAX and conditional logic. Selected_Level = IF( ISFILTERED(States[StateName]), "District", // If a state is selected, show district data "State" // If no state is selected, show state-level data )

[@khushbooyadav9047]

Thank you .

[@kotivemula]

Thank you

[@subhashiniravi-r1s]

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

[@KSRDatavizon]

We will provide you the Answer here Soon Ravi.!

[@KSRDatavizon]

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)

[@KSRDatavizon]

Answer to your 2nd Question : IF(HASONEVALUE(sales[country]), SELECTEDVALUE(sales[country])) & IF(HASONEVALUE(sales[country]), VALUES(sales[country]), BLANK())

[@pav6926]

In which company u have attended mam and through which source(LinkedIn or naukri)

[@khushbooyadav9047]

Please provide sql queries questions for power bi interview

[@KSRDatavizon]

kzbin.info/www/bejne/aGrNe6xqqaaChqc

[@KSRDatavizon]

kzbin.info/www/bejne/oamzfaCVjpmomrM

[@KSRDatavizon]

kzbin.info/www/bejne/jHKyoYB-lM6Lg6M

[@KSRDatavizon]

Hi Khushboo, Hope the below videos will help you with SQL Quarries Questions

[@subhashiniravi-r1s]

mam i was attend kadel labs from bangulore location i was receiving mail throuh noukri

[@dilipinamdar5523]

Nice!!!!!!

[@bchandra912]

Please share dataset

[@KSRDatavizon]

github.com/ksrpowerbi/KSR_DAX_Datasets

[@vinodkumarhs4000]

Hello Madam can i get job as power bi fresher

[@KSRDatavizon]

Call us on 8951796123 for more details