Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

New Calculated Column with If and Sum

Hi All, Please help me with the DAX for calculated column in PowerBi : I am trying to create a new column using below formula from Excel in PowerBi   Denied Access:=IF(SUM(Details[NCC Denied Acces...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    4 years ago

    if you are create a calculated column in DAX, the code may be

    Denied Access=IF(Details[NCC Denied Access] > 0, Details[NCC Denied Access])

wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
4 years ago

if you are create a calculated column in DAX, the code may be

Denied Access=IF(Details[NCC Denied Access] > 0, Details[NCC Denied Access])