Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
    Anonymous
    Not applicable
    5 years ago

    Anonymous no luck unfortunately  

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      could you explain better what you mean by no lucky?
      if you want useful help, you have to provide maximum information, otherwise it is difficult to imagine what happens

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi Anonymous ,

         

        Your M below has not worked, but I believe it needs an if statement in there. I would expect something a bit more like "= if([EndTime] > [Interval End] then [Interval End]-[EndTime]else 0)" would be the answer I need? 

        Kind regards,

         

        Jordan