Forum Discussion

g-wizard's avatar
g-wizard
Frequent Visitor
2 years ago

Case Calc conversion

Hello Team,

I have a question on converting this calc into Dax in PowerBi.

 

CASE [Calc Pos%] WHEN [Time Period(Months)] THEN 1
ELSE 0 END

 

Calc Pos% is a database column with integers.

Time Period(Months) is a paramter 

DAX

1 Reply

  • d_gosbell's avatar
    d_gosbell
    Super User
    2 years ago

    If these are both columns in the same table then you could either use IF or SWITCH to do the same sort of logic in a calculated column. Or you could create a view in SQL and just pull in the result.