Forum Discussion

jiangchuan23's avatar
jiangchuan23
Frequent Visitor
8 years ago
Solved

How to create Dynamic Decile group column?

Hey All,   I was trying to create a dynamic decile variable to group credit score. Here is the column formula I created   Column = IF(gains_total[CBR_SCR]<PERCENTILE.EXC(gains_total[CBR_SCR],0.1)...
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi jiangchuan23,

     

    Since the new declie column is a calculated column, whose values are initialize once it is created. Its value won't be dynamically changed depend on slicer selection.

     

    Regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi jiangchuan23,

 

Since the new declie column is a calculated column, whose values are initialize once it is created. Its value won't be dynamically changed depend on slicer selection.

 

Regards,

Yuliana Gu

jiangchuan23's avatar
jiangchuan23
Frequent Visitor
8 years ago

Thanks. It would be good for power BI to add  this type of functions in the future

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    There are way too many things that seems so obviously needed in Power BI that drive me crazy... just like this!