Forum Discussion
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...
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 , merge using left join EOW and end of week in power query
and then add a custom column in the power query
if [Date of joining] < [End of week] then "Present"
Merge : https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Thanks for replying.
Merging wont fetch the missing week for each student right?
Let me know if there is a way to get the missing week for every student using join.
