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?
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!
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.
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 )
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
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)
![Power BI DAX Tutorial - Beginner to Advanced [Full Course]](/img/n.gif)
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.
Thank you. Please provide the data set in the description
github.com/ksrpowerbi/KSR_DAX_Datasets
Thank you.
Please make more videos on DAX and Data Modelling
ua-cam.com/video/VttUwZfJwJw/v-deo.html
awesome session
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
hiii good morning mam vry use full vedio thank u mam
Thank You Ravi.!
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?
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!
Nice Video
Thanks for the visit, Please subscribe our channel for regular updates.
U r doing very nice work..
Please provide the dataset link in the description.Thank you.
github.com/ksrpowerbi/KSR_DAX_Datasets
Thanks , very helpful !
Thank you .
Thank you
How did you join Measures_TB table to Bikes table?
Nice!!!!!!
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.
After doing charts.. lock the objects
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.
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
)
Please tell about the use of concatenate x also
sure
Hi Mam ,From where we can this excel as a data source ,Can you please provide this ?
All dataset links is attached in discrpitiom
Please provide sql queries questions for power bi interview
ua-cam.com/video/29jJy4tAOPE/v-deo.html
ua-cam.com/video/kxPLm_Y4udQ/v-deo.html
ua-cam.com/video/VAOpMH_iXMA/v-deo.html
Hi Khushboo, Hope the below videos will help you with SQL Quarries Questions
mam i was attend kadel labs from bangulore location i was receiving mail throuh noukri
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)
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