Forum Discussion
ALRUYOYO
Advocate I
Advocate IGiving values to filtered column
Hi, I took a screenshot of table view. And then of a sample of what I am trying to accomplish. So I would like to add a column to table view which assigns levels if the total amount per month is...
1.You need to create a static table for the band. Name the table as Band.
2. The columns should be Position, BandDescription, MinValue, MaxValue
3. The rows could be something thing like
1, < 7500, 0, 7500
2, 7501 - 20000, 7501,20000
3, 20001 - 30000, 20001, 30000
and so on depending on the band that you want to go upto
4. Create a column in the fact table defined as
GroupPosition = CALCULATE (
VALUES ( Band[Position] ),
FILTER (
Band,
FactTable[Value] >= Band[MinValue]
&& FactTable[Value] <= Band[MaxValue]
)
)