divide 3 columns in dax

[PSan1979]

Hi Experts,

I want to divide 3 columns which come directly frm DB.

round((@StuAct / nullif(@StuCount,0) / nullif(@WorkingHrs,0) ) / 6,1)

[amitchandak]

@PSan1979 , Try like

round(divide(divide([StuAct] , coalesce([StuCount],0)) ,coalesce(@WorkingHrs,0) ) / 6,1)

[AllisonKennedy]

@PSan1979  are you using import or direct query? You can do this as a calculated column pretty straightforward, or do do it as a measure you will need to add an aggregation (such as SUM, AVERAGE or MAX)

Please can you describe what output you want in words, not just SQL?