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.
I have a and excel file with TEXT columns and date values have been stored in those columns. for eg:
Few of the cells have been formatted as type General (until 14/12/20)
and anything after 14/12 is formatted as Customised.
Power Query throws error fro this cell onwards (15/12) meaning from where the format is set to customised.
How do I resolve this error.
Note: This file is quite huge and I need to find a permanent solution via Power Query to handle this as every week the data will come out of the source system in this format only.
Please find the sample data below
02-Dec-20 A | 02-Dec-20 A | 03-Dec-20 A | 03-Dec-20 A | 07-Dec-20 A | 08-Dec-20 A | 08-Dec-20 A | 09-Dec-20 A | 10-Dec-20 A | 10-Dec-20 A | 10-Dec-20 A | 10-Dec-20 A | 11-Dec-20 A | 11-Dec-20 A | 11-Dec-20 A | 14-Dec-20* | 14-Dec-20* | 15-Dec-20 | 15-Dec-20 | 16-Dec-20 | 16-Dec-20 | 17-Dec-20 | 17-Dec-20 | 18-Dec-20 | 18-Dec-20 | 23-Dec-20 A | 05-Jan-21 | 07-Jan-21 | 07-Jan-21 | 13-Jan-21 | 13-Jan-21 | 13-Jan-21 | 13-Jan-21 | 14-Jan-21 | 15-Jan-21 | 15-Jan-21 | 15-Jan-21 | 15-Jan-21 | 25-Jan-21 | 25-Jan-21 | 25-Jan-21 | 25-Jan-21 | 26-Jan-21 | 26-Jan-21 | 26-Jan-21 | 26-Jan-21 | 28-Jan-21 | 28-Jan-21 | 28-Jan-21 | 29-Jan-21 | 29-Jan-21 | 29-Jan-21 | 02-Feb-21 | 03-Feb-21 | 03-Feb-21 | 03-Feb-21 | 03-Feb-21 | 05-Feb-21 | 09-Feb-21 | 10-Feb-21 | 12-Feb-21 | 12-Feb-21 | 16-Feb-21 | 17-Feb-21 | 17-Feb-21 | 22-Feb-21 | 22-Feb-21 | 22-Feb-21 | 22-Feb-21 | 22-Feb-21 | 22-Feb-21 | 23-Feb-21 | 23-Feb-21 | 24-Feb-21 | 24-Feb-21 | 26-Feb-21 | 26-Feb-21 | 01-Mar-21 | 01-Mar-21 | 01-Mar-21 | 02-Mar-21 | 03-Mar-21 | 03-Mar-21 | 05-Mar-21 | 08-Mar-21 | 08-Mar-21 | 08-Mar-21 | 08-Mar-21 |
Solved! Go to Solution.
@smjzahid , you may want to try
Table.SelectRows(#"Added Index", each Date.From([Finish])>#date(2020,12,14))
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
@smjzahid , you may want to try
Table.SelectRows(#"Added Index", each Date.From([Finish])>#date(2020,12,14))
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
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.