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.
Solved! Go to Solution.
sorry saw my syntax error and corrected it.
This worked if I chnaged the MID expression to MID('table'[date],2,2) for 7 character dates and MID('table'[date],3,2) for 8 character dates
successful formulae below
thank you very much
@PStokes Please try below formula. in case it doesn't work for you please share two three record for each formate
DDMMYYYY = DATE(RIGHT('Table'[Date],4),MID('Table'[Date],3,2),LEFT('Table'[Date],2))
In case of DMMYYYY please check the length of column and if it is 8 then you can use above else
dMMYYYY =
VAR _length = len('table'[column])
RETURN IF(_length=7,DATE(RIGHT('Table'[Date],4),MID('Table'[Date],3,2),LEFT('Table'[Date],1)),DATE(RIGHT('Table'[Date],4),MID('Table'[Date],3,2),LEFT('Table'[Date],2)))
Thanks, I tried to add colum and use the VAR as written but received a sytax error
Examples of the data below.
Date Text |
1012019 |
21012019 |
27112019 |
8112019 |
sorry saw my syntax error and corrected it.
This worked if I chnaged the MID expression to MID('table'[date],2,2) for 7 character dates and MID('table'[date],3,2) for 8 character dates
successful formulae below
thank you very much
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
18 |