Forum Discussion
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...
Hi kalpana,
you can make a new column of "Date" type which will have the substracted date; via the following:
New Column = [Date Created] - 1
See if this meets your requirement.
For data type conversion on your coulmn "Date Created", check out the following links:
- https://community.powerbi.com/t5/Integrations-with-Files-and/Date-Display-Formats/td-p/2145
- https://msdn.microsoft.com/en-us/library/mt253512.aspx
Hope it helps.
i tried this formula only i am getting error