get max value as column

[zara81]

i have a table whith different time date column (eg openTime, closeTime, waitTime).

i need a new column with max from datediff opentime-closetime and datediff opentime-waittime.

thx

[zara81 · Accepted solution]

i solve with minx or maxx

thx

[Anonymous]

Hi @zara81,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng