Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi all,
I am importing maintenace records into a report and it is literally a dump of data containing a maintenance end date. I don't care about dates in the past and I thought I could setup a conditional column at the time of importing to just say something like if maint end date >= today(), 1, 0 and then just filter the list for the 1.
I can't seem to set that up in the way I thought, is there a way to do it at the initial import to just trim the data out I don't need?
ta
Solved! Go to Solution.
Hmm, that's a good questions. At some point, there needs to be an evaluation of the data.
I usually do my import through SQL, where SQL can evaluate the data, before it's imported by doing: Date > '01-01-2020' to restrict import.
But when importing a CSV, i think the only evaluation happens in power query 🤷
Hmm, that's a good questions. At some point, there needs to be an evaluation of the data.
I usually do my import through SQL, where SQL can evaluate the data, before it's imported by doing: Date > '01-01-2020' to restrict import.
But when importing a CSV, i think the only evaluation happens in power query 🤷
Depends on how you are importing the data and from where
Just a CSV import from a filer location
I made a measue then slapped that in as a filter for the data that is being displayed.
User | Count |
---|---|
91 | |
84 | |
64 | |
62 | |
58 |
User | Count |
---|---|
148 | |
112 | |
95 | |
81 | |
71 |