Forum Discussion
Dynamic column Value
I have this column in powerbi, a concatenation of my FY column which is the fiscal year that consists FY24 and FY25, and Period column which consists of P1 to P12. I also created a Period Numbe...
This is what I've tried and did not work.
Created a measure:
Selected Period =
VAR SelectedVal = SELECTEDVALUE(vw_Tableau2[Period])
return
IF(SelectedVal = "P1",1,
IF(SelectedVal = "P2",2,
IF(SelectedVal = "P3",3,
IF(SelectedVal = "P4",4,
IF(SelectedVal = "P5",5,
IF(SelectedVal = "P6",6,
IF(SelectedVal = "P7",7,
IF(SelectedVal = "P8",8,
IF(SelectedVal = "P9",9,
IF(SelectedVal = "P10",10,
IF(SelectedVal = "P11",11,
IF(SelectedVal = "P12",12))))))))))))
Created a column:
Created a column:
Period Checker =
IF(vw_Tableau2[Current FY?] = BLANK(),"Yes",
IF([Selected Period] = 1, "Yes",
IF([Selected Period] = 2,
IF(vw_Tableau2[Period Number] <= 2,"Yes"),
IF([Selected Period] = 3,
IF(vw_Tableau2[Period Number] <= 3,"Yes"),
IF([Selected Period] = 4,
IF(vw_Tableau2[Period Number] <= 4,"Yes"),
IF([Selected Period] = 5,
IF(vw_Tableau2[Period Number] <= 5,"Yes"),
IF([Selected Period] = 6,
IF(vw_Tableau2[Period Number] <= 6,"Yes"),
IF([Selected Period] = 7,
IF(vw_Tableau2[Period Number] <= 7,"Yes"),
IF([Selected Period] = 8,
IF(vw_Tableau2[Period Number] <= 8,"Yes"),
IF([Selected Period] = 9,
IF(vw_Tableau2[Period Number] <= 9,"Yes"),
IF([Selected Period] = 10,
IF(vw_Tableau2[Period Number] <= 10,"Yes"),
IF([Selected Period] = 11,
IF(vw_Tableau2[Period Number] <= 11,"Yes"),
IF([Selected Period] = 12,
IF(vw_Tableau2[Period Number] <= 12,"Yes","No"))))))))))))))
Returning result:
regardless of the selected period, the column returns YES to all rows. Seems the the measure is not dynamically working in a calculated column
Returning result:
regardless of the selected period, the column returns YES to all rows. Seems the the measure is not dynamically working in a calculated column
Calculated columns and tables are generate on semantic model refresh. Slicer selection will have no effect, on these