Forum Discussion
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 Access]) > 0, SUM(Details[NCC Denied Access]), blank())
Thansk in advance.
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])
2 Replies
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])