Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dynamic Column

Problem Statement

 

I have a filter which is:
1. Current Cycle

Table Structure:
Year Cycle Quarter Period
2020 202002 Q1 P01
|        |             |    |
2020 202002 Q4 P13

 

2019 201913 Q1 P01
|         |            |    |
2019 201913 Q4 P13


I want a column that needs to be dynamically implemented

 

Example 1
Current Cycle: 202002
Column should have
Period: P01 -> A
Period: P02-P13 -> B

 

Example 2
Current Cycle: 201913
Column should have
Period: P01-P12 -> A
Period: P13 -> B

 

I have developed a DAX but that create a measure and poeses some difficulties in the visualization field plus for my further calculation i want a dynamic column

KPI Time Indicator =
VAR __current_cycle =
IF (
[FilterSelected_CurrentCycle] = "201913",
[FilterSelected_CurrentCycle],
VALUE ( RIGHT ( [FilterSelected_CurrentCycle], 2 ) )
)
VAR __period =
VALUE ( RIGHT ( SELECTEDVALUE ( DataModel[Period] ), 2 ) )
RETURN
IF (
__current_cycle = "201913",
"A",
IF ( __period < __current_cycle, "A", "B" )
)

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous 

     

    Columns can not be dynamic.

    Columns are get loaded at the first load only.

     

    Incase you want something dynamic you need to use measures.

     

     

    Thanks & regards,
    Pravin Wattamwar
    www.linkedin.com/in/pravin-p-wattamwar

    If I resolve your problem Mark it as a solution and give kudos.