Forum Discussion

Wise1's avatar
Wise1
Helper I
9 years ago

DAX Formula for subtracting

Hello All,   I have been trying to figure the following out for the last 2 days without any luck,    Basiclly what iam trying to achieve is  Client - has allocated 10 hours a month 4 hrs worth ...
Need Help
Wise1's avatar
Wise1
Helper I
9 years ago

Yep, using powerBi Desktop and using Direct Query

  • parry2k's avatar
    parry2k
    Super User
    9 years ago

    What is the data type for the field in SQL? What I can see from your screen shot, it is treating the field as string than number field. Can you click on the table as per screen shot 1 and then select modelling table, select field and change it to number (not sure if direct query allows that), if not then probably you need to create a column using dax and convert it to number:

     

     

     

     


    DAX Convert String to Value

     

    Add new column called, for example new column is called myValue

     

    myValue = VALUE(Table1[TextField])

    I didn't tested above formula but we can always fix it in case there is an issue.

     

    Thanks,

     

     

     

     

     

     

     

     

     

    • Wise1's avatar
      Wise1
      Helper I
      9 years ago

      Thanks,

       

      The PowerBi desktop doesnt have that circled calandar icon, not sure if its the same thing, but i have changed the type here; 

       

       

       

      • parry2k's avatar
        parry2k
        Super User
        9 years ago

        Yes this is correct, becuase of live connection, you don't see that circled image which I sent. My bad.

         

        Hope it fixed your issue.