Forum Discussion
Convert Julian date to nomal date
Hello everyone,
I got a problem convert JULIAN DATE to NOMAL DATE
- Julian date format: 2022265 -> 21-09-2022
Can anyone help me to write the DAX in PBI , thank you!
Hi Aalice_hos ,
I found another topic about this issue:
https://community.powerbi.com/t5/Desktop/7-Digit-Julian-Date-conversion/m-p/122102
Try this calculated column as mentioned in that topic where
TheTable = your table name
[JulianDate] = name of your julian date columncaldate = DATE ( INT ( DIVIDE ( TheTable[JulianDate], 1000 ) ), 1, MOD ( TheTable[JulianDate], 1000 ) )
Sample output
2 Replies
- m_alireza
Solution Specialist
Hi Aalice_hos ,
I found another topic about this issue:
https://community.powerbi.com/t5/Desktop/7-Digit-Julian-Date-conversion/m-p/122102
Try this calculated column as mentioned in that topic where
TheTable = your table name
[JulianDate] = name of your julian date columncaldate = DATE ( INT ( DIVIDE ( TheTable[JulianDate], 1000 ) ), 1, MOD ( TheTable[JulianDate], 1000 ) )
Sample output Amazing! Thank you so much
