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 having an issue converting Julian Dates of 2020 and 2019. I am currently using the below for a new column and it is working for Julian dates that start with 0 but for ones that start with 9 it's returning 2029 and I'm needing it to return 2019, how can I make this happen? My dates are 4 digits, 9347, 0146, 0003, etc
Solved! Go to Solution.
The myYear variable is never going to return anything less than 2020.
If the year is either 2019 or 2020, then in the absence of anything more elegant:
VAR myYear = IF (INT(DIVIDE(TableJul[Column1],1000)) = 9, 2019, 2020)
As far as I understand Julian dates are contiguous. Where does the 1000 come into play here? Shouldn't you be using all digits of the Julian dates?
I'm new to Power BI and I stole that formula doing a google search so I'm not sure where the 1000 is coming from or what it is doing. I'm open to any suggestions on changes.
The myYear variable is never going to return anything less than 2020.
If the year is either 2019 or 2020, then in the absence of anything more elegant:
VAR myYear = IF (INT(DIVIDE(TableJul[Column1],1000)) = 9, 2019, 2020)
@HotChilli That just gets me the year, I need to turn 9001 to Jan 1, 2019 or 0001 to Jan 1 2020.
That's right. You can do the substituting into your original formula.
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 |
---|---|
39 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |