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...
Hi JofrainVisda
Can you please try the below DAX.
output =
VAR SelectedPeriod = MAX('Table'[Period Number])
RETURN
IF(
MAX('Table'[Period Number]) <= SelectedPeriod,
"Yes",
"No"
)
If you found this post helpful, please accept it as the solution.