Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi My date format centure date(7 numbers)
example:1170228
left to right:first number is centure1 for 20,0 for 19
then two digit is years mean 197 mean 2017 years
then 02 mean MM
then 28 is DD
I need date format 2017/02/28
Please any help on DAX formal or any Power Bi date format option availble
Thanks
Aruna
Solved! Go to Solution.
@Aruna_ln,
You can change the data type of the Date column to Date.
Regards,
Lydia
@Aruna_ln,
Create the following columns in your table.
Column = IF(LEFT(Table[Column1],1)="0","19","20")
Date = Table[Column]&MID(Table[Column1],2,2) &"/"& MID(Table[Column1],4,2) &"/" &RIGHT(Table[Column1],2)
Regards,
Lydia
Thanks You but ineed data type is Date
@Aruna_ln,
You can change the data type of the Date column to Date.
Regards,
Lydia
User | Count |
---|---|
88 | |
72 | |
69 | |
65 | |
57 |
User | Count |
---|---|
95 | |
93 | |
91 | |
75 | |
69 |