Absolutely! She's truly incredible, and we’re so glad you noticed. ❤ If you enjoy this kind of content, don’t forget to subscribe and stay tuned for more amazing insights!
converting to date column using dax : Dax date = DATE( LEFT('Whone to Date'[date column],4), MID('Whone to Date'[date column],5,2), RIGHT('Whone to Date'[date column],2) )
LEFT: Extracts the first 4 characters, which represent the Year. MID: Extracts 2 characters starting at position 5, representing the Month. RIGHT: Extracts the last 2 characters, which represent the Day. DATE: Combines these extracted values into a proper Date format in Power BI. Ensure 'Whone to Date'[date column] is a text column, as this formula assumes text input. If it’s already numeric, you might need to convert it to text first using FORMAT or ensure the numeric operations align. The output of this formula will be in Power BI's Date data type.
Thank You, Please subscribe our channel for regular updates. this video was made by one of our student who cracked the interview, sorry if any mistakes as she was new for making sessions. our intension just to share her experiance with us. hope you cna understand
This is for freshers only..also most of the optimisation of queries can be done in SQL only... For two fact tables u can select required columns from two different tables and then union all. Select distinct customerid from table1 Union all Select distinct customerid from table2
Optimizing SQL Queries for Freshers: A Quick Tip! When working with two fact tables, remember that most of your query optimization can be done directly within SQL. 💡 Here’s a simple tip: If you need to retrieve distinct customer IDs from two different tables, you can select the required columns from both tables and use the UNION ALL operation to combine the results.
![TCS Power Bi Interview Questions And Answers ||🔥[ 2021 ]🔥](http://i.ytimg.com/vi/WoFUmg80nTQ/mqdefault.jpg)
O my god , this lady has so much knowledge ❤
Absolutely! She's truly incredible, and we’re so glad you noticed. ❤ If you enjoy this kind of content, don’t forget to subscribe and stay tuned for more amazing insights!
converting to date column using dax : Dax date =
DATE(
LEFT('Whone to Date'[date column],4),
MID('Whone to Date'[date column],5,2),
RIGHT('Whone to Date'[date column],2)
)
LEFT: Extracts the first 4 characters, which represent the Year.
MID: Extracts 2 characters starting at position 5, representing the Month.
RIGHT: Extracts the last 2 characters, which represent the Day.
DATE: Combines these extracted values into a proper Date format in Power BI.
Ensure 'Whone to Date'[date column] is a text column, as this formula assumes text input. If it’s already numeric, you might need to convert it to text first using FORMAT or ensure the numeric operations align.
The output of this formula will be in Power BI's Date data type.
1st question - simple step change the number data type to text and then change the data type into date
we can do it in DAX also using the combination of Date, LEFT, RIGHT and MID Functions..or we can use the Date.From function in the custom column
Thank You for Your comment, Please subscribe our channel for regular updates and it Motivates us a lot 🙏🏼
Finished watching
Thank You
Question 5, i had tried but could not have done. How you can help me?
could you please share us the errro pic and your querrey in Detailed
These questions are typically asked for candidates with how many years of experience
3-5 years experienced people
How how many years experience these questions are for..
it helps for 3-5 years experiance people.
For Que-2
Need any more information ?
Where is round 1?
th-cam.com/video/_DPYCkUivvM/w-d-xo.html
Please create a video on how to write a Power BI resume for someone with 1-2 years of experience.
sure kiran, we will make a video on the same,
Question No 5 ,it should be ALLSELECTED not ALL
Thank You, Please subscribe our channel for regular updates. this video was made by one of our student who cracked the interview, sorry if any mistakes as she was new for making sessions.
our intension just to share her experiance with us. hope you cna understand
yes it should be ALLSELECTED to work perfectly..
This is for freshers only..also most of the optimisation of queries can be done in SQL only...
For two fact tables u can select required columns from two different tables and then union all.
Select distinct customerid from table1
Union all
Select distinct customerid from table2
Optimizing SQL Queries for Freshers: A Quick Tip!
When working with two fact tables, remember that most of your query optimization can be done directly within SQL.
💡 Here’s a simple tip: If you need to retrieve distinct customer IDs from two different tables, you can select the required columns from both tables and use the UNION ALL operation to combine the results.