Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
I am trying to do an IF statement comparing a column containing dates. Basically, I want to say IF an order date is between two dates, it is labeled as year 1.
If the order date is between 9/15/2015 and 8/31/2016, then it would be labeled as Buy Year 2016.
If the order date is between 9/1/2016 and 8/31/2017, then it would be labeled as Buy Year 2017.
Can I do this with an IF statement? What is the best approach. The column with the order date is labeled as a date column.
Go to Solution.
View solution in original post
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.