Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello.
I am grabbing data into a CSV file on a daily basis.
The date column that i want to create a relationship with my date table is coming through like ths
How can i get Power Query to automatcally turn Today into Todays date and Yesterday into Yesterdays date? - We can remove time for now, as i just want to relate ton the date.
Thanks for any tips
Solved! Go to Solution.
How are you getting the files is it based on the Folder?
If yes you need to go to remove the step remove other columns, then add the new column based on the creation date and after that delete all the columns that are related with the folder:
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @PPStar ,
If you are getting the files from a folder just keep the column Date created or date modified after doing the function call then use a conditional column like this:
if Text.Contains ([Star time] , "Today" ) then [Date created] else
if Text.Contains ([Star time] , "Yesterday" ) then
[Date created] - #duration(1,0,0,0)
else
[Start Time]
this may need to be adjusted.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThe files will be manually dropped into a folder on a daily basis.
The Date Created column is not part of the table.. Where do i get that from.
Can i not juts change the [Date Created] to Now() or something similar?
How are you getting the files is it based on the Folder?
If yes you need to go to remove the step remove other columns, then add the new column based on the creation date and after that delete all the columns that are related with the folder:
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
106 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |