Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
hey,
i have an problem to convert simple text to a date since today, and i dont know why. (it worked till yesterday)
i have the following rows / dax formula:
This is the row i need to convert. If i change the format, i get an error. (text to date not possible)
So, i used these formulas to extract part of the dates and put it together.
Jahr = PATHITEM(SUBSTITUTE(StandardVerkauf[Verkaufsvorgang.Vorgangsdatum];"-";"|");1)
Monat = PATHITEM(SUBSTITUTE(StandardVerkauf[Verkaufsvorgang.Vorgangsdatum];"-";"|");2)
Datum = StandardVerkauf[Monat] & "." & StandardVerkauf[Jahr]
Jahr = Year, Monat = Month, Datum = Date (translation)
This results in this
The row Datum is set to Date Format and it worked perfectly till today. When i now update / refreseh my dataset, i get the following error for the column Datum.
Translation: The Value "." of type text can not be converted to the type date.
Same if i try to convert only the year.
Datum = StandardVerkauf[Jahr]
Same error.
Can someone help me please? 🙂
Solved! Go to Solution.
Hi @DennisJung,
You can use power query date functions to split the date column, add a custom column to store them.
Sample:
#"Added Custom" = Table.AddColumn(#"Renamed Columns", "Year", each Date.Year([Created])), #"Added Custom1" = Table.AddColumn(#"Added Custom", "YearMonth", each Date.ToText([Created],"yyyy.MM"))
Reference link:
Regards,
Xiaoxin Sheng
Hi @DennisJung,
You can use power query date functions to split the date column, add a custom column to store them.
Sample:
#"Added Custom" = Table.AddColumn(#"Renamed Columns", "Year", each Date.Year([Created])), #"Added Custom1" = Table.AddColumn(#"Added Custom", "YearMonth", each Date.ToText([Created],"yyyy.MM"))
Reference link:
Regards,
Xiaoxin Sheng
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |