Forum Discussion

bangerasid's avatar
bangerasid
Icon for Helper I rankHelper I
4 years ago
Solved

DAX - Help Needed (row level check)

Hi Team,   I have the below scenario.   I am trying to create the master table based on End of Week & Attendance tables. However, when I am doing this, i want to consider the Date of Joini...
General Comment
Need Help
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    You may download the solution workbook from here.  I have used the Query Editor in MS Excel to solve the question.  Implement the same steps in PowerBI Desktop.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

You may download the solution workbook from here.  I have used the Query Editor in MS Excel to solve the question.  Implement the same steps in PowerBI Desktop.

bangerasid's avatar
bangerasid
Icon for Helper I rankHelper I
4 years ago

Hi Ashish,

 

Thanks for the response. I want to do it at DAX level and not at power query, reason being the dataset is huge, for each ID there are around 10k rows.

I am just trying to compare if(joined on > end of week, "Exclude", "Include").
However, to do this, I am not able to get the end of week value in the highlighted area.

values are coming for all the fields except for when the student has no attendance.

 

Used the below formula.
m_endofweek measure = VALUES(Weeks[End of Week])