Forum Discussion
Power Query / M - If statement with Duration
Hi all, I'm looking for a bit of help converting a column built with DAX into PowerQuery. Time for next period = if('Master Append'[EndTime] > 'Master Append'[Interval End] , datediff('Mast...
solved this, seems the brackets used were not allowing me to complete the M code.
Solution was = if [EndTime] > [Interval End] then Duration.Seconds([EndTime] - [Interval End]) else 0
I don't know the DAX sintax at all, but for what I can understand, would suggest to try this:
#"Time for next period" =List.Max({Duration.Seconds(#"Master Append"[Interval End]-#"Master Append"[EndTime]),0}
If you want, as seems from picture, add a new column with this data you shoul put the left right of the expression on the tool
add custom tool
Anonymous no luck unfortunately