Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Ok I have a column in my data that has the year and month of an item captured.
The issue is that it is a text field that lists it as text in this format:
YYMM
I know I could split these and recombine them in the correct order and format it as date but that would take several steps.
Is there a more efficient way to perform this funtion?
Solved! Go to Solution.
Are all the years in the 2000s ?
you may have to modify the above if your column is only the last 2 year digits - YYMM
Column = DATE("20"&LEFT([Test],2), RIGHT([Test],2), 1)
If the column is called [Test] and if the format is YYYYMM, I generally do
= DATE(LEFT([Test],4), RIGHT([Test],2),1)
Careful about the year though. In your case, you only have YY instead of YYYY, so might have to concatenate 19 or 20 based on what you want.
Are all the years in the 2000s ?
you may have to modify the above if your column is only the last 2 year digits - YYMM
Column = DATE("20"&LEFT([Test],2), RIGHT([Test],2), 1)
Thanks this woked
Interesting I'm getting an error that the name date wasn't recognized?
Forgot to tell you, I did this in DAX (the modelling side) and not in M (query editor side)
User | Count |
---|---|
134 | |
72 | |
72 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
65 | |
62 | |
53 |