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

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 

    • Anonymous's avatar
      Anonymous
      Not applicable
      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

      Hi Anonymous 

      you didn't explained what error my code raises.

       

      The logic of the expression I give is the same of your if ... then .. else. Only written in a differente way.

       

      But now I have seen an error in the sintax

      this

      List.Max({Duration.Seconds(#"Master Append"[Interval End]-#"Master Append"[EndTime]),0}

       

      should be

       

      List.Max({Duration.Seconds(#"Master Append"[Interval End]-#"Master Append"[EndTime],0})