Measure Logic to display certain status names

[jakaihammuda]

Hi,

Im struggling to create logic that works, i basically want to display the status name of each process entity. Each process entity is only written to the DB once, if it is successful upon first try, so there would then only be one row. However, if the process entity fails, it will retry and then succeed. so in that case there wuld be 2 rows for the same process entity, one failure and one success. Or we can also see the process entity as "In Progress", if at the time of accessing the report the process is still running. I want to write logic which displays the status name of each process entity (if theres only one row thats easy as it only has one option), but if there are two rows for one process entity then i want it to display the status name of the latest process entity row, which would be the success and it wont end until its succeeded. else just display the status name.

there is also a column for processstarttime which helps identify the timings.

[Anonymous]

In Power Query, try using the Pivot tranformation on a copy of the query to get those row values as columns for display

[jakaihammuda]

is this supported via direct query?

[Anonymous]

yes, Power Query supports DirectQuery sources