Forum Discussion

drivas771994's avatar
drivas771994
Icon for Helper II rankHelper II
8 years ago
Solved

Is there a formula for calculating the difference between rows.

Hi,   I'm trying to calculate the difference between two values in the same column. For example, I have a student (John Doe) who took one test on 9/1/2018 and received a 76 and then retook the test...
Need Help
drivas771994's avatar
drivas771994
Icon for Helper II rankHelper II
8 years ago

So currently when I plug that formula in I get some syntax errors. Formula with syntax error

All of my columns are spelled correctly. Am I doing something wrong here?

 

 

  • drivas771994's avatar
    drivas771994
    Icon for Helper II rankHelper II
    8 years ago

    The formula seems to work well. The only problem I'm running into is that Power bi is saying that dax comparison options cannot compare a date to text for the calculated column

     

    • Zubair_Muhammad's avatar
      Zubair_Muhammad
      Icon for Community Champion rankCommunity Champion
      7 years ago

      drivas771994

       

      Could you share the screenshot of your datatable with the formula?

      Or share the file if you can?