Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm looking to figure this out on how to set it so if the registrations dates are between May 3rd, 2021 and May 3rd, 2022 its FY22. Anything after May 4th, 2022 and beyond is FY23
Table.AddColumn(#"Changed Type2", "Registration Year", each if [FirstNewDate] >= #datetime(2021, 5, 3, 0, 0, 0) then "FY22" else if [FirstNewDate] < #datetime(2022, 5, 3, 0, 0, 0) then "FY22" else if [FirstNewDate] >= #datetime(2022, 5, 4, 0, 0, 0) then "FY23" else "FY23"),
Instead of it ouputting for any dates past May 4th, 2022 as FY23 it's listing them as FY22. Any suggestions as to why this is happening?
Thanks!
Solved! Go to Solution.
Use this
= Table.AddColumn(#"Changed Type", "Registration Year", each if Date.From([FirstNewDate])>=#date(2021,5,3) and Date.From([FirstNewDate])<=#date(2022,5,3) then "FY22" else "FY23")
@Vijay_A_Verma this is why I love this community! :D. Thank you that worked like a charm!
Use this
= Table.AddColumn(#"Changed Type", "Registration Year", each if Date.From([FirstNewDate])>=#date(2021,5,3) and Date.From([FirstNewDate])<=#date(2022,5,3) then "FY22" else "FY23")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |