Forum Discussion

Helper I

9 years ago

Need help

Hi In a particular folder, i want to merge all files(txt files) from sharepoint. i got it for merging all files. but the thing is i want to filter the file if the particular word is present insid...

Community Champion

9 years ago

Thanks for confirming I understood correctly.

Watch this video for better explanation.

It reads files from a folder (rather than Sharepoint, but the concept is the same) and returns only files containing the keyword.

Helper I

9 years ago

Thank you very much Marcel

I need one more help. There are two tables . i want to do lookup to get the values from other table .

Need formula for lookup with condition.

I tried this = Lookupvalue(result column name, search column name, search value ) but here i want to put condition,

Is it possible.?

MarcelBeug
Community Champion
9 years ago
Doesn;t look like (standard) Power Query to me, so I don't think I can help you.

If it isPower Query, then I need more clarification, because I don't understand exactly what you are looking for.

Otherwise I would advise to raise a new topic with a descriptive title (not "Need Help"), something like "How to perform a conditonal lookup in DAX".
- kalpana
  Helper I
  9 years ago
  This one will list the name of files and created date. from this, I want to subtract 1 from date created . but i cannot change this even to date (data type) also. when i am subtracting it is giving error
  - kalpana
    Helper I
    9 years ago
    In Data also, Date created is showing empty.
v-huizhn-msft
Microsoft Employee
9 years ago
Hi kalpana,

Thanks for detail description. As the MarcelBeug pested, please open a new thread. In the forum, there is one issue in one thread. And your second question is not related to the first one. If you ask some problem about, you'd better post sample data and expected result. Thanks for understanding.

Best Regards,
Angelia