Forum Discussion
Adding a Date Column to an existing Table that references date of source
Hello,
You need to extract the values left of the "_" Delimiter. This should leave you with an 8 digit number 20240610, etc.
From here there are two ways to get the date. One through Power Query M in transform data, or DAX (my preferred way). For the DAX you can use a combo of LEFT, MID, and RIGHT respectively to get your YEAR, MONTH, and DAY.
Thank you. This worked.
I will mention that the other tables that had the date added did not do it this way, so I was skeptical that the result would work for what I needed (a global date selector on the front page, based on the date modified data of the Excel files) - but it did!!!! So thank you. I can't believe how much time I spent trying to do this some weird Invoke function way....
Impactful IndividualGreat! Glad that helped resolve your problem 🤠Please mark my response as a solution so that other users may find it helpful too