Calculated Column DAX

[rohitjmd]

hello, please help me having a Calculated column on below requirement. Test file attached for reference.

Test file

[Greg_Deckler · Accepted solution]

Well, you could do it in DAX. The basic pattern is this.

For Adhoc

Get the MINX of ALL rows that match the project ID (use EARLIER)

Check if your current date matches that date, if so 1, otherwise 0

For Tracker it is the same pattern but you will want to do some additional filtering to make sure that you are only grabbing a month's worth of data, so in that MINX statement, also check that the MONTH and YEAR are the same as the current row (again, use EARLIER)

[Greg_Deckler · Accepted solution]

Well, you could do it in DAX. The basic pattern is this.

For Adhoc

Get the MINX of ALL rows that match the project ID (use EARLIER)

Check if your current date matches that date, if so 1, otherwise 0

For Tracker it is the same pattern but you will want to do some additional filtering to make sure that you are only grabbing a month's worth of data, so in that MINX statement, also check that the MONTH and YEAR are the same as the current row (again, use EARLIER)

[rohitjmd · Accepted solution]

Thanks @Greg_Deckler  for the idea. I have achieved the final outcome though little differently. i am using Indexing from Query editor and DAX  EARLIER and MINX as you suggested to achieve it. Below is the final Dax expression.Thanks very much.