Forum Discussion
Mema
6 years agoFrequent Visitor
Greatest difference
I have a table that has 3 columns that make up a unique identifier, I have combined these in a new column. I have been able to do the difference for each one of these for each period in the financial...
Mema
6 years agoFrequent Visitor
you for your response, I get the error EARLIER/EARLIEST refers to an earlier row context which doesn't exist
dax
6 years agoCommunity Support
Hi Mema,
Above expression is used on calculated column, not in measure.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mema6 years agoFrequent Visitor
I have tried it as a column and I get
A Single value for column 'ManageCodeKey' in the table 'CombinedData' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result