Forum Discussion
jiangchuan23
8 years agoFrequent Visitor
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)...
- 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
8 years agoFrequent Visitor
it sounds like tableau have a way to do it.
https://community.tableau.com/thread/224377
Do somebody know how I can replicate this in power BI ?