Forum Discussion
Helper VFind column with the earliest date
Hi,
When I create a calculated table with the DAX function CALENDARAUTO, the first date in the resulting table is a ridiculous earlier date (1/1/0200). This means that somewhere in the model I have a date column that contains a date from that year. The challenge is that my model contains hundreds of date columns in dozens of tables. How can I systematically find the column that contains that earliest date without having to inspect (sort) each column by hand?
Any ideas?
I'm open to use external tools. Maybe DAX Studio can help?
2 Replies
- ribisht17
Super User
Write a one-time code
Then reuse it ,
Regards,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau UsersRegards,
Ritesh
juan_pabloThank you for your reply but that's kind of the same as going through all columns manually. Literally there are hundreds of dates so just recalling the names of each to write the formula would take me the same as sorting them one by one.
Thank you anyway!!
