Forum Discussion
Calculated Column DAX
hello, please help me having a Calculated column on below requirement. Test file attached for reference.
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)
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.
2 Replies
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)
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.