Dynamic Column

Anonymous — Thu, 13 Feb 2020 18:23:47 GMT

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

Re: Dynamic Column

Anonymous — Wed, 19 Feb 2020 07:42:07 GMT

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.

topic Re: Dynamic Column in DAX Commands and Tips

Dynamic Column

Re: Dynamic Column