Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello all,
I have from date and to date columns with data as
From date
010318
050625
090524
i want to convert this to date format, when i change directly in power bi it is giving the wrong values. I also used Dax as
Solved! Go to Solution.
HI @Anonymous
For your formula, you just need to keep the format of this formula same with your local system.
For example:
In my computer, my date format is mm/dd/yyyy
So I adjust your formula as below:
FROMDATE1 = MID(MC859A01[FROM DATE],3,2)&"/"&RIGHT(MC859A01[FROM DATE],2)&"/"& LEFT(MC859A01[FROM DATE],2)
Then change the datatype to date
Regards,
Lin
Hi,
This M code works
let
Source = Excel.CurrentWorkbook(){[Name="Dates"]}[Content],
#"Added Custom" = Table.AddColumn(Source, "Custom", each Date.From(Text.From("20"&[From Date], "en-US")))
in
#"Added Custom"
Hope this helps.
HI @Anonymous
For your formula, you just need to keep the format of this formula same with your local system.
For example:
In my computer, my date format is mm/dd/yyyy
So I adjust your formula as below:
FROMDATE1 = MID(MC859A01[FROM DATE],3,2)&"/"&RIGHT(MC859A01[FROM DATE],2)&"/"& LEFT(MC859A01[FROM DATE],2)
Then change the datatype to date
Regards,
Lin
@Anonymous in Power Query just use:
#date("yyyy string", "mm string", "dd string")
This should work
if possible, please give example
@JirkaZ I dint get you what you exactly mean..are you telling to create a new column in query editor. if so, column created in query editor cant be used in normal desktop
@Anonymous that's exactly what I'm saying. Why wouldn't you be able to use a column created in Power Query in the report/desktop?
@Anonymous No - it's M definition for the new column
@Anonymous Or you can use this definition of a column (assuming the dates are all after year 2000).
@JirkaZ in the from date column few date values are 0. so when i use the given formula its throwing error as value .So, is it possible to replace this error with some blank date
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
68 | |
53 | |
39 | |
33 |
User | Count |
---|---|
70 | |
63 | |
57 | |
49 | |
46 |