Forum Discussion
Advocate IIConvert Month Named Columns to Dates
I believe I am understanding correctly now.
So the MOTNH( ) function actually works opposite. You give PBI a month, and it returns a number that coorespondes to that date.
One way is the use = FORMAT(DATE(1, 4, 1), "MMM")
The returned value for this is 'Apr'
Let me know if this helps you out
Hmmm, could you share the file? Or a few screenshots?
Advocate IIHi, Anonymous !
Below, you can see the excel file from which I'm getting the data:
You can see above that the column headers are month names and I need to consolidate them into a column, I can have it displayed on a timeline chart.
Below, you can see the table I am creating:
In the hilighted area, you can I tried MONTH(4), thinking it'd set the month to April, but the column Date underneath shows (01/01/2019). This is the biggest question!
Can't thank you enough for looking into this.
Regards,
Antonio
I believe I am understanding correctly now.
So the MOTNH( ) function actually works opposite. You give PBI a month, and it returns a number that coorespondes to that date.
One way is the use = FORMAT(DATE(1, 4, 1), "MMM")
The returned value for this is 'Apr'
Let me know if this helps you out
- Asantos2020
Well...just so this date gets updated as the files coming overtime, I've done it this way, then: FORMAT(DATE(YEAR(TODAY());4;1);"dd/MM/yyyy").
Thank you! Cheers!