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...
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
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
Hi kalpana,
You want to subtract 1 day from date created, right? If it is, please try the following formula and check if it works fine.
New Column = DATE(YEAR([Date Created]),MONTH([Date Created]),(DAY([Date Created]) - 1))
Best Regards,
AngeliaI Checked it, it s not working fine. i am getting error that date is not recognized