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.
How do I create a conditional column with values for fiscal year date ranges "9/1/2011 to 8/31/2012"?
Solved! Go to Solution.
Something like this:
if Date.Month([Column1]) < 9 then Date.Year([Column1]) else Date.Year([Column1]) + 1
Please check at your side because I just rushed it.
It's generally considered good practice to do this sort of thing in a date table and use a relationship to link to the data. Plenty of resources out there.
Something like this:
if Date.Month([Column1]) < 9 then Date.Year([Column1]) else Date.Year([Column1]) + 1
Please check at your side because I just rushed it.
It's generally considered good practice to do this sort of thing in a date table and use a relationship to link to the data. Plenty of resources out there.
It worked, thank you!!! Good to know, I will look into date tables.
Could you provide more detail please? Do you want to add a column in Power Query according to a date in your data already? or something else?
Yes, in Power Query, I have a Transaction Date column and want to add a column that calculates Fiscal Year based on the transaction date ranges.
In Excel I used the formula below, I tried to replicate it in a Conditional Column and then tried copying it into a Custom Column, neither worked.
=TEXT(YEAR([@[Transaction Date]])+IF(MONTH([@[Transaction Date]])>8,1,0),0)
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |