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 have one data source giving me trouble because it is DD-MM-YYYY formatted. When I change the data from text to date, Power BI is not consistent with numbers in the day or month column below 12. I need to have the month data accurate so I can define a Fiscal year starting in May using the syntax below.
Can anyone help ensure my date can transfer the month data accurately?
Fiscal Year = IF(MONTH('NC Reg''n'[Current Registration Status Date])>4,YEAR('NC Reg''n'[Current Registration Status Date])+1,YEAR('NC Reg''n'[Current Registration Status Date]))
Thanks,
Val
Solved! Go to Solution.
Thank you very much. My data is a little messed up right now after trying a few ways. I'll try your suggestion and let you know how it goes in the next few days.
Thanks so much for your time and advice.
Val
Thanks but it didn't change anything.
Should I use some sort of Table? I really don't care for the exact day but I do want the month and year to be accurate.
Any other suggestions?
Val
Thank you very much. My data is a little messed up right now after trying a few ways. I'll try your suggestion and let you know how it goes in the next few days.
Thanks so much for your time and advice.
Val
Looks like the 2nd solution worked. I was not linking to UK English like you suggested.
Thanks a ton.
Val
Try create a column like
new date =
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |