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.
Is this possible? I've hightlighted the result in red
I tried doing this OFFSET= CALCULATE( MAX(Roles), OFFSET(-1, ALLSELECTED(Employee), ORDERBY( Date,1)) but gives me an error.
Solved! Go to Solution.
Hi @peterhui50
I can use this measure based on your sample data.
OFFSET Measure = CALCULATE( MAX('Table (2)'[Roles]), OFFSET(-1, ALLSELECTED('Table (2)'[Roles]), ORDERBY( 'Table (2)'[Roles],1)))
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi @peterhui50
I can use this measure based on your sample data.
OFFSET Measure = CALCULATE( MAX('Table (2)'[Roles]), OFFSET(-1, ALLSELECTED('Table (2)'[Roles]), ORDERBY( 'Table (2)'[Roles],1)))
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Is there a way to make the same code but without using offset and orderby?
I need the same formula, but the version I have doesn't allow me to use those features
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |