Dynamic Column

[singh_gagan30]

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" )
)

[Anonymous]

Hi @singh_gagan30 

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.