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.
Hi there, I had some help me get to this formula
I've made a date table in power query and I'm looking to add a fiscal year column in the format 2023-24
if (Date.Month([Date])) <=3 , number.ToText(Date.Year([Date])) & "-" & Text.End(Number.ToText(Date.Year([Date])+1),2)) , Number.ToText(Date.Year([Date])+1) & "-" & Text.End(Number.ToText(Date.Year([Date])+2),2))
However it gives me the error "Token 'then' expected", could someone help me figure this out?
Solved! Go to Solution.
I think you might be mixing up the DAX syntax with Power Query syntax on this. To debug, simplify the code, use dummy values until you get it to work, then introduce the more complex code.
Start with this
if Date.Month([Date]) <=3 then "a" else "b"
I think you might be mixing up the DAX syntax with Power Query syntax on this. To debug, simplify the code, use dummy values until you get it to work, then introduce the more complex code.
Start with this
if Date.Month([Date]) <=3 then "a" else "b"
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 |
---|---|
98 | |
96 | |
75 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |