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.
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.
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 |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |