Forum Discussion
cottrera
Post Prodigy
Post ProdigyDAX - Calculating distributed age using a distribution table
Hi Has a property address table with 3 columns produced by source data. Column #4 is a calculated column that produces the age of the property in years (decimal) I also have a second table that...
cottrera , you can create a new column like
Switch(True(),
[Build Age Years] >100,"100 + Years",
[Build Age Years] >90," 90 - 100 Years",
[Build Age Years] >80," 80 - 90 Years",
// add others
"0-10 Years" //default
)add additional conditions as per need
amitchandak
Super User
Super Usercottrera , you can create a new column like
Switch(True(),
[Build Age Years] >100,"100 + Years",
[Build Age Years] >90," 90 - 100 Years",
[Build Age Years] >80," 80 - 90 Years",
// add others
"0-10 Years" //default
)
add additional conditions as per need