Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Change SQL to DAX

Hi. I have these 2 SQL clauses I need to use in PowerBI measure. This one I need to add decimals = Rivisumma alv 0% = SUMX ( 'ol', [price] * ( [quantity] ) / (1 + [alv] /100)) This is how I do ...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , Try like

    round(SUMX ( 'ol',divide( [price] * ( [quantity] )*1.0 ,(1 + [alv] /100.0))),2)

    Change data type to decimal. You can Avoid round by giving it column/measure tools

     

    SUMX('ol' , Switch(True(), ol[price] > 0 , ol[quantity] , ol[price] < 0 , -1* ol[quantity] , 0 ))

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Try like this in DAX - 

Rivisumma alv 0% = SUMX ( 'ol', [price] * ( [quantity] ) / (1 +  [alv] /100))

Rivisumma alv 0% = 
VAR A = SUMX ( 'ol', [price] * ( [quantity] )
VAR B = 1+ Divide([alv],100,0)
Return
Divide(A,B)

Measure_2 =
Switch(True(),

ol.price >0, sum(ol.quantity),

ol.price < 0, write the comdition here like above,
0
)


 

hope this helps.

 

Regards,

Hemant