TCS - DAX based Power BI Interview Question😲 | Must Watch

[@learnwidgiggs]

Dataset link: docs.google.com/spreadsheets/d/1lhVCRJ6F2XFA6pCzHLf6oP5zDC6b0UXx/edit?usp=sharing&ouid=102679157628567582944&rtpof=true&sd=true

[@amitgajkal4821]

A simplified solution could be Column = CALCULATE( MAX('Table'[Transaction Date]), FILTER( 'Table', 'Table'[Transaction Date] < EARLIER('Table'[Transaction Date]) ) )

[@meghalohar2367]

I just tried this approach. thanks for sharing

[@SatheeshPK-jg1dg]

Hi Guys, Below Dax also works the same way: Using Earlier = MAXX(FILTER(Date_Master, Date_Master[Date] < EARLIER(Date_Master[Date])), Date_Master[Date]) Using Offset = CALCULATE(MAX(Date_Master[Date]), OFFSET(-1,ALL(Date_Master[Date]))) Using Window Function = CALCULATE(MAX(Date_Master[Date]),WINDOW(0,ABS,-1,REL,ALL(Date_Master[Date]))) If u have a seperate id its fine the above dax only requires the date column nothing else ....

[@learnwidgiggs]

@@SatheeshPK-jg1dg thanks for sharing the alternate solution.

[@SatheeshPK-jg1dg]

@@learnwidgiggs fan of ur work Shashank

[@rahulmehla2014]

Hlo Shashank, this is my solution: Result = CALCULATE( MAX('Table'[Transaction Date]), FILTER('Table','Table'[ID] = EARLIER('Table'[ID])-1) )

[@Yash_15_10]

yes it also works 👍

[@oKUNDURUVYSHNAVI]

Can I know why we use Max function here

[@rahulmehla2014]

@@oKUNDURUVYSHNAVI first of all we need to give a expression here which means a single value should be there so max give the maximum value in the current filter context i.e. a single value

[@ritudhuriya3009]

Hi! I was asked this power bi question recently in an interview. Could you please help with the solution? Appreciate your help! The question is - I have one date slicer which select the start and end date using drag feature, and a second slicer which has list - last 7 days, last 15 days, last 21 days. the basis of second slicer will be the end date selected in the first slicer. Next I have a clustered bar chart having dates (categorical) on y axis and sales on x axis (day wise). when I make a selection in the second slicer accordingly the dates should be visible in the chart. How to implement this?

[@Pooja_Bhanu]

Thank you so much Shashank for sharing the dax related content. Useful

[@learnwidgiggs]

@@Pooja_Bhanu welcome 🙂

[@aakashmohan9827]

Result = LOOKUPVALUE(Table' [Transaction Date], 'Table' [ID], 'Table' [ID]-1)

[@MiteshYadav]

I have faced similar kind of situation while working in my organization.. Data contained water sensor data where I needed to subtract and group by data based on daily, in that I needed to subtract first data after or equal to 12:00 am with last data before 12 am..

[@suchitraroutray4705]

Hi sir, Could you please share solution of this query.. Write a dax to create a date table where day should starts from today and it should be automatically incrememted for 3yrs u shouldn't hardcode the end date here.. How to write the dax

[@sreesri6747]

I created new column and used previousday dax It worked well. Please correct me if I am wrong

[@Aaradhya_Jauhari]

OFFSET , WINDOW(ABS REL)🤔

[@loosuloosudon4494]

Can be done

[@buzzfeedRED]

Go To 1:27

[@New2you09]

Variables have pretty much replaced the need for the earlier function

[@nemo7606]

Sir I want to become a business analyst. Can you tell me the best business analyst course.

[@C15-k4d]

In pbirs opening folders and paginated reports but datasource manage data base page showing as something went wrong and please try again later

[@sameerkale7282]

Not getting calls for Power Bi developer or Data Analyst. Please give me some suggestions.

[@AashishTelgote-x4g]

No jobs

[@hnsri94]

Are you fresher or experienced ?

[@Ramkuntal2000]

thanks! 🙌

[@VandanaSatwani]

Facing trouble in DAX FORMULA in custom column how to solve

[@owncreatechannel6426]

Nice explanation

[@learnwidgiggs]

@@owncreatechannel6426 thank you 🙏

[@KomalSharma-qc6th]

Sir, i have done a virtual data analyst internship on 360digitmg and i missed the deadline by 1 hr because they closed the project on sunday so i didn't get the certificate. So in that case what i need to do? Should i still put this internship in my experience section or just add it to the project section? For now i am using it in my project section but i am bit confused...I will look forward to hearing from you soon.

[@learnwidgiggs]

Projects section.

[@KomalSharma-qc6th]

@@learnwidgiggs okay! Thankyou for your esponse.

[@amolgaikwad6977]

Very well explained, Sir..

[@learnwidgiggs]

@@amolgaikwad6977 glad you liked it 🙏

[@the_legends1989]

It's possible with Lookup as well😅

[@raushankumarpandey897]

What if I'd column is not there..?plz suggest

[@rajm5349]

Hi sir, what is unit test in powerbi and thanks for making the videos.

[@chethan4160]

Offset we can use

[@Rajveer1-x3s]

Hi Shashank...... If file size is greater than 1gb then how can we import data? Will u plz...give solution?

[@SatheeshPK-jg1dg]

we can still load data greater than 1 gb inside the power query it uses the vertipac and x-velocity engine to compress the data And while pushing the data inside the power bi if it is greater than 1gb even after the data compression is done it will not load the data into the power bi model otherwise it will.

[@mahendra951]

Can it be done without ID column?, if yes, can you please explain?

[@learnwidgiggs]

@@mahendra951I'm not sure about it.

[@mmadhurrr]

We can use rankx to create a id type column and use the same logic. This way it can be done without id column.

[@SatheeshPK-jg1dg]

ID is not required check out my comment for multiple ways. (It works for me) Below Dax also works the same way: Using Earlier = MAXX(FILTER(Date_Master, Date_Master[Date] < EARLIER(Date_Master[Date])), Date_Master[Date]) Using Offset = CALCULATE(MAX(Date_Master[Date]), OFFSET(-1,ALL(Date_Master[Date]))) Using Window Function = CALCULATE(MAX(Date_Master[Date]),WINDOW(0,ABS,-1,REL,ALL(Date_Master[Date]))) If u have a seperate id its fine the above dax only requires the date column nothing else ....

[@zenjiyt8381]

@@SatheeshPK-jg1dg offset one will throw an error of " a circular dependency was detected"

[@Itsme65467]

write a dax query for below mentioned scenario
I Have Joining date and end date in employee table
- now need to calculate the total number of active employees 
- where end date is blank consider it as active employee
- where end date is greater than today consider it as active employee
-joining date is less than end date consider it as active employee till before end date consider employee as active ex: (joining date - 1-Jan-24, end date - 15th Aug 2024) so the employee should be active till before end date for example mentioned table format should be the final result date  Active  left  join
Jan   135   6  0
Feb  132   4  3
Mar  129   20  1
Apr  112   4  3
may  109   0  1
Jun  112   5  3
Jul  109   5  2
Aug  109   1  5
Sep  113   0  5
Oct  0   0  0
Nov  0   0  0
Dec  0   0  0 Can you please help me with this