Forum Discussion

Emiliano's avatar
Emiliano
Regular Visitor
7 years ago
Solved

SWITCH

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
Tips and Tricks
  • Emiliano's avatar
    Emiliano
    7 years ago

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

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
      Emiliano
      Regular Visitor
      7 years ago

      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's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi Emiliano ,

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

        Regards,
        Xiaoxin Sheng