Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
Hi, I want to add a column that indicate if the year is the current year, a previous year or next year , I have already a calender Table called Dates, so I tried this Dax function but it didn't work for me
YearSlice = IF('Dates'[Year]=YEAR(NOW()),"Current Year",'Dates'[Year] = YEAR(NOW())-1,"Previous Day",'Dates'[Year] = YEAR(NOW())+1,"Next Year"," ") I am new at Power BI Dax Functions so please can someone help me
Solved! Go to Solution.
YearSlice = IF('Dates'[Year]=YEAR(NOW()),"Current Year",IF('Dates'[Year] = YEAR(NOW())-1,"Previous Year",IF('Dates'[Year] = YEAR(NOW())+1,"Next Year","Other Year")))
YearSlice = IF('Dates'[Year]=YEAR(NOW()),"Current Year",IF('Dates'[Year] = YEAR(NOW())-1,"Previous Year",IF('Dates'[Year] = YEAR(NOW())+1,"Next Year","Other Year")))
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
| User | Count |
|---|---|
| 50 | |
| 42 | |
| 36 | |
| 31 | |
| 29 |
| User | Count |
|---|---|
| 129 | |
| 129 | |
| 59 | |
| 48 | |
| 47 |