Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
91 | |
89 | |
79 | |
69 | |
68 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |