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
wynhopkins's avatar
wynhopkins
Most Valuable Professional
9 years ago

Can you convert the SLA Hours to values on import in the Query editor?

Wise1's avatar
Wise1
Helper I
9 years ago

I cant do anything under the Query Editor as its using SQL Direct access (i think its called) 

- Still learning PowerBi so if there is a way to do it, im willing to give it a shot or do some reading on how its done 

    • 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,