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.
Dears,
Have a good day.
I need to get the last value of a column, just read it without calculation as the value is a cumulative value.
Solved! Go to Solution.
Hi aserag,
In your scenario, you want to achieve the value in the last row, right? For example, 54545 is what you want in column [Planned value] below.
The first solution is that you can create an index and use the max index to find the value, click Query Editor->Add Column->Index Column.
After applied, you can create a measure using DAX formula:
last value = CALCULATE(MAX(Table1[Planned Value]), FILTER(Table1, Table1[Index] = MAX(Table1[Index])))
The second solution is that you can simply use “Keep Bottom Rows” to achieve last value.
Regards,
Jimmy Tao
What if I want to take the last 5 elements insted of just one?
Hi aserag,
In your scenario, you want to achieve the value in the last row, right? For example, 54545 is what you want in column [Planned value] below.
The first solution is that you can create an index and use the max index to find the value, click Query Editor->Add Column->Index Column.
After applied, you can create a measure using DAX formula:
last value = CALCULATE(MAX(Table1[Planned Value]), FILTER(Table1, Table1[Index] = MAX(Table1[Index])))
The second solution is that you can simply use “Keep Bottom Rows” to achieve last value.
Regards,
Jimmy Tao
Hi @v-yuta-msft
Thank you very much, I prefer the 1st solution. I tried it and it's working.
Thanks again
Regards
Ahmed
Hi @v-yuta-msft ,
I have read your solutions and have tried solution 1 partially.
Here's how my current table looks after indexing -
DESIRED VALUE = 51.7 M
Current Calculation:
Will it always be the highest value? If so you could use MAX([Planned Value (Cumulative)]
Thank you @Phil_Seamark
But in my case it is not, it depends on other values so it is not the highest vale.
Then do you have another column that is used to determine the order to get the last value? Is it a Date column or transaction ID
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 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |