I have a DAX query in Power BI.
I have created a new column in the data and I want to Group AgeWhenFirstSold(Mo) into Age buckets.
The result I get from this query is 0-5 Months but the 6-11 Months doesn't show in the column
Group AgeWhenFirstSold(Mo)- 6 Months =
IF (
AND ( Sheet1[AgeWhenFirstSold(Mo)] >= "0", Sheet1[AgeWhenFirstSold(Mo)] <= "5" ),
"0 - 5 Months",
IF (
AND ( Sheet1[AgeWhenFirstSold(Mo)] > "5", Sheet1[AgeWhenFirstSold(Mo)] <= "11" ),
"6 - 11 Months"
)
)