Is there really no way to create something close to a calculated column while using live conection

[Lephantis]

I want to substitute the data on a column (IF numero = 11 THEN 6), and it would be easy with a calculated column. The problem is that I can't make one (Since I'm using live connection). Is there any other way I can do this?

[v-xinruzhu-msft · Accepted solution]

Hi  @Lephantis 

When you use a live connection, you cannot modify its model, so you cannot create calculated columns, and you can create measures.

e.g 

Measure=If(SELECTEDVALUE('Table'[numero])=11,6)

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.