https://community.fabric.microsoft.com/t5/Report-Server/Case-Calc-conversion/m-p/3456987#M31273 <P>If these are both columns in the same table then you could either use <A href="https://learn.microsoft.com/en-us/dax/if-function-dax" target="_self">IF</A> or <A href="https://learn.microsoft.com/en-us/dax/switch-function-dax" target="_self">SWITCH&nbsp;</A>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.</P> Tue, 03 Oct 2023 04:36:43 GMT d_gosbell 2023-10-03T04:36:43Z https://community.fabric.microsoft.com/t5/Report-Server/Case-Calc-conversion/m-p/3456346#M31266 <P>Hello Team,</P><P>I have a question on converting this calc into Dax in PowerBi.</P><P>&nbsp;</P><P>CASE [Calc Pos%] WHEN [Time Period(Months)] THEN 1<BR />ELSE 0 END</P><P>&nbsp;</P><P>Calc Pos% is a database column with integers.</P><P>Time Period(Months) is a paramter&nbsp;</P> Mon, 02 Oct 2023 16:32:20 GMT https://community.fabric.microsoft.com/t5/Report-Server/Case-Calc-conversion/m-p/3456346#M31266 g-wizard 2023-10-02T16:32:20Z https://community.fabric.microsoft.com/t5/Report-Server/Case-Calc-conversion/m-p/3456987#M31273 <P>If these are both columns in the same table then you could either use <A href="https://learn.microsoft.com/en-us/dax/if-function-dax" target="_self">IF</A> or <A href="https://learn.microsoft.com/en-us/dax/switch-function-dax" target="_self">SWITCH&nbsp;</A>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.</P> Tue, 03 Oct 2023 04:36:43 GMT https://community.fabric.microsoft.com/t5/Report-Server/Case-Calc-conversion/m-p/3456987#M31273 d_gosbell 2023-10-03T04:36:43Z