calculated field in tableau to power Bi

[Prathyusika]

How to convert below formula to power bi:

if ((0.5 * (zn([columnname]/0.8))) * 100) > 50 then 50 else
(0.5 * (zn([columnname]/0.8))) * 100 end

please help

[DOLEARY85]

Hi,

try:

Column = IF(CALCULATE(0.5*sum('Table'[Column1])/0.8*100) > 50,50,CALCULATE(0.5*sum('Table'[Column1])/0.8*100))

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[DOLEARY85]

If you need to account for blanks fields use:

Column = if(isblank(IF(CALCULATE(0.5*sum('Table'[Column1])/0.8*100) > 50,50,CALCULATE(0.5*sum('Table'[Column1])/0.8*100))),0,IF(CALCULATE(0.5*sum('Table'[Column1])/0.8*100) > 50,50,CALCULATE(0.5*sum('Table'[Column1])/0.8*100)))

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍