SWITCH

[Emiliano]

I'm using the following formula to populate a specific column of a table:

Limite = SWITCH('Tabella FIP CDA'[ordine];3;[Bond];2;[Corporate])

Tha tabe has 3 colums: ordine( constant numbers from 1 to 26), Limite, Data (each end of month of last 2 year)

Bond and Corporate are 2 measure time dipendent but they don't change when I change the year in filter page why?

If I put Bond and Corporate in another table they change with time so I can'be a problem of that measures but It's probably specific of the function SWITCH.

Thanks in advance

[Anonymous]

HI @Emiliano ,

Did you mean you are try to create a calculated column to use switch to check current row and return measure result?

If this is a case, power bi not support to use slicer/filter to create a dynamic calculated column.
Measure are calculated based on its row contents, if you use it in calculated column. Its row contents will be fixed as whole table and return static result.

Regards,

Xiaoxin Sheng

[Emiliano]

The measures are calculated outside table with data outside the table but they are only put in the table in each rows with function SWITCH (each row has a different measure) and they have to change with time filter but the don't. 

[Anonymous]

Hi @Emiliano ,

Can you please share some sample data with export result to help us clarify your scenario?

Regards,
Xiaoxin Sheng

[Emiliano · Accepted solution]

I got the solution bymyself it's enough to use SWITCH(TRUE()