Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I have this chart that I made that creates grouping with the help of ChatGPT. But I realized that I was missing data, some of the data has blank date of brith because the babies have not been born yet. I would like to create a condition that if there is blank then put it in the category "Preterm".
Chat GPT is telling me to use this but I cannot get it to work:
= Table.AddColumn(#"Total Years", "Custom", each if Table.IsEmpty([Age]) or [Age] = null then "Preterm" else if [Age] <= 0.0833 then "Newborn (0 to 1 Month)" else if [Age] <= 1 then "Infant (1 to 12 Months)" else if [Age] <= 3 then "Toddler (1 to 3 Years)" else if [Age] <= 6 then "Preschool (3 to 6 Years)" else if [Age] <= 12 then "School Age (6 to 12 Years)" else "Adolescents (12+ Years)" )
Can someone help me through this one please?
Hi @wherdzik
Please share your table to work with.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
85 | |
66 | |
51 | |
45 |
User | Count |
---|---|
216 | |
89 | |
82 | |
66 | |
57 |