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

[@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 🙂

[@Aaradhya_Jauhari]

OFFSET , WINDOW(ABS REL)🤔

[@loosuloosudon4494]

Can be done

[@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

[@the_legends1989]

It's possible with Lookup as well😅

[@nemo7606]

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

[@New2you09]

Variables have pretty much replaced the need for the earlier function

[@sreesri6747]

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

[@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.

[@VandanaSatwani]

Facing trouble in DAX FORMULA in custom column how to solve

[@raushankumarpandey897]

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

[@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 ?

[@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

[@Ramkuntal50]

thanks! 🙌

[@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

[@rajm5349]

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

[@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

[@owncreatechannel6426]

Nice explanation

[@learnwidgiggs]

@@owncreatechannel6426 thank you 🙏

[@buzzfeedRED]

Go To 1:27

[@amolgaikwad6977]

Very well explained, Sir..

[@learnwidgiggs]

@@amolgaikwad6977 glad you liked it 🙏

[@chethan4160]

Offset we can use

[@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"

[@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.

[@aakashmohan9827]

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