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

You should have a proper date column i.e. without the ordinals such as rd, th.  Share data in a format that i can paste into MS Excel with my suggested change.

  • bangerasid's avatar
    bangerasid
    Icon for Helper I rankHelper I
    4 years ago
    End of Week
    11/06/2022
    18/06/2022
    25/06/2022

     

     

    IDEOWHire Date
    1018/06/202213/06/2022
    1025/06/202213/06/2022

     

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

      I am getting the following output, however, the expected output should have "Exclude" in place of "Include" at the highlighted cell.

       

       

    • 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])