We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register 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")))
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 57 | |
| 40 | |
| 36 | |
| 18 | |
| 18 |
| User | Count |
|---|---|
| 70 | |
| 67 | |
| 38 | |
| 34 | |
| 23 |