Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
hello, please help me having a Calculated column on below requirement. Test file attached for reference.
Solved! Go to 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)
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |