• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

DAX/Conditional Column

P

Penuel

New Member
Hi guys, How can I add a conditional column or DAX for column generation? If the year of birth is within the range of 1960-1980 it will flash (baby boomers) 1980-2000 (Gen X) 2000 to 2020 (Millenials). I'm new in power bi appreciate your help guys, Thanks! please see the snip below of my error formula 78035
 
Using Power Query within Power BI Add a new column

each if [Year]>1959 and [Year]<1981 then "Boomer" else if [Year]>1979 and [Year]<2001 then "Gen X" else "Millenial")

Source refers
 
You must log in or register to reply here.
Back
Top