Forum Discussion
Conditional Column when creating a new column
Hi, So i have a new column that is not inside in my actual table so i want to do a conditional column but couldn't find my "new column" that i just created. here's my new column: bu...
Assuming you have the column [no of mths] in Power Query available, you can try this formula
if Number.RoundUp([no of mths]/12,0) > 10 then " >Yr 10" else Text.Combine({"Yr ",Number.ToText(Number.RoundUp([no of mths]/12,0))})
Hi both no of months and no of yrs are new columns that i created in power bi desktop hence when i check inside the power query i can't find either one of them. 😞