Using the below table I am trying to calculate a filed to refelct the privious recorded value with the restrictions set by the filter. For some reson the value that returns is basically double what I expect.
Hi @JLET ,
In the filters, 'TEST Electric Meters Summerized'[Attribute]=EARLIER('TEST Electric Meters Summerized'[Attribute]) is grouped according to Attribute.
What do below two filters do?
And if there's no order internally for records in table when you want to get previous row. You have to add an index column in your table. Please refer to
Solved: How to get previous row value for text column. - Microsoft Power BI Community
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
118 | |
62 | |
56 | |
47 | |
40 |
User | Count |
---|---|
110 | |
65 | |
61 | |
53 | |
47 |