Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Differrance betwee two values in rows

Hi, I got the follwing issue.   in a table i got a number of maximum times allowed. In a other table i got the times given.   Now i want to see all rows where the given times are greater than t...
Need Help
  • Jimmy801's avatar
    Jimmy801
    6 years ago

    Hello Anonymous 

     

    the solution I proposed is Power Query. That what you are stating is DAX. 

    If the DAX solution is okay, go for it. 

    However, if you are copying my code into the advanced editor, it should not spin. Is a straightforward code. This is the result of combining the example data in my code

     

    Jimmy

Jimmy801's avatar
Jimmy801
Community Champion
6 years ago

Hello Anonymous 

 

copy the data into the advanced editor. You don't have appended any screenshot, but I suppose you have copied into the formula bar

 

Jimmy

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Jimmy,

I'd copied it in the avanced editor.

 

I got another solution where they say:

Difference = (COUNTA('Codering max trances' [Max omvang standaard eenheid ZIN]) - COUNTA('FeitLevering'[aVolume])

 

This looks like a simple solution, However for some reason there is no result. (The wheel keeps spinning)

  • Jimmy801's avatar
    Jimmy801
    Community Champion
    6 years ago

    Hello Anonymous 

     

    the solution I proposed is Power Query. That what you are stating is DAX. 

    If the DAX solution is okay, go for it. 

    However, if you are copying my code into the advanced editor, it should not spin. Is a straightforward code. This is the result of combining the example data in my code

     

    Jimmy

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Jimmy801 

    Yes its work now 🙂

     

    I'd tried it in a current table, now i just made a new query 🙂

     

    Thanx a lot