expressions
2 Topics
How to use DAX expression to find all distinct ids between certain dates
Hello, I just have a quick question. So, we have a table called "Not_messaged' that has information about candidates. These fields are lastMessageDate (Date field), id (integer field), NotesMessageDate (Date field), and CallNotesLogDate (Date field). what we want is to return a distinct count of ids that: Do NOT have messagedLastSentDate before today's date OR DOES NOT have callNotesLogdate = todays date OR DOES NOT have NotesLogDate = today's date I am trying to come up with a DAX expression that can return a distinct count of the ids. However, we are getting stuck because we're not good at DAX expressions.Solved1.2KViews0likes5Comments
Measure to count active employees in a period based on Slicer Calendar
Hi, I have a table which contains employees DateStarted and Leavedates. Leavedates is NULL if they are still active. In SQL I would run a where statement based on SSRS date parameters to only include active in a month period for example, where (LeaveDate >= @datefrom and DateStarted < @dateto) or (DateStarted < @dateto and LeaveDate is NULL) so if I replace the parameters with dates where (LeaveDate >= '01 May 2020' and DateStarted < '01 Jun 2020) or (DateStarted < '01 Jun 2020) and LeaveDate is NULL) ... so this captures anyone who were active for any portion of this month for example, or even start before and finish after etc. I am struggling to convert this to a measure so I can display a count of employees on a 3D card, based on a date slider linked to a calendar table, making this value dynamic. Thank you in advance.Solved2.8KViews0likes1Comment