Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I need on the follow table a formula that will extract just last value. (94.118,74)
the filter to apply are:
thanks in advance for your help
Solved! Go to Solution.
I am sorry. I thought you wanted a measure that would give you 1 value to use in a visual. Upon rereading this, I see that you are really looking for a column. There may be a better way to do this and I am sure that you can consolidate this, but I have run out of time. So, I created some columns mostly with if statements and added them to the table. It is not pretty, but I believe it works.
I added 4 columns which as I said you can probably consolidate:
Proud to be a Super User!
Hi @GiuseppeTE ,
Try this, my table is 'Find Shift'.
Proud to be a Super User!
Hello Nathaniel,
thanks for your feedback but are not work as I need.
Infact the result is on the last column on the follow table.
I need the last one value by the formula. In the case below 15618,22
Hi @GiuseppeTE ,
So the last one does not have a status = 200?
What does your formula return?
Nathaniel
Proud to be a Super User!
hello
you are right.
I made a mistake the last one have to be linked with 200.
The picture I attached is the result of your formula.
Giuseppe
Hi @GiuseppeTE ,
So do you think it is working?
I dummied up a table with the last rows from your picture. However I did notice that of the rows that I used, the last column values were the same, so I put in unique values. The second picture shows the result of 15, which is what I would expect, unless I do not understand your question.
What sort of data is this? I am just curious...
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
Hello Nathaniel and thanks for your curiosity. Really I need to solve the issue and maybe I semplified too much the real table I have to manage.
Anyway here below your last formula with the results on my table.
So let me tell you that in my table there are 50columns and 330.000 row.
Now the formula I am looking for have extract the value of actualcycletime corrispondent at the last date available, max shift, with status 200. So on the picture above is 7074110,43.
In addition if this can help you, for me is not so necessary to select the status (200), but absolutly I have to select the value of actual_cycle available at the:
Thanks
Giuseppe
I am sorry. I thought you wanted a measure that would give you 1 value to use in a visual. Upon rereading this, I see that you are really looking for a column. There may be a better way to do this and I am sure that you can consolidate this, but I have run out of time. So, I created some columns mostly with if statements and added them to the table. It is not pretty, but I believe it works.
I added 4 columns which as I said you can probably consolidate:
Proud to be a Super User!