Forum Discussion
Date Addition to the report
Dear PowerBI experts,
I'm pulling data through API and building a report. Since the application that I'm pulling data does not capture the date, is there a possiblity to add a date column in my report whenever I refresh the data? Using this I can tag the metrics to certain date.
Note: If I refresh today I want the column to add today's date for the newly added data through API, rest of the existing data should reflect that day date when I refreshed it.
Basically any new addition post refresh should take that refresh date.
Yes, and No. In Power Query, you can add a column that is DateTime.Date(DateTime.LocalNow()) which will return today's date, but it will be on all records. Power Query won't keep track of what is new. It is all new on every refresh. It does all of the data.
1 Reply
Yes, and No. In Power Query, you can add a column that is DateTime.Date(DateTime.LocalNow()) which will return today's date, but it will be on all records. Power Query won't keep track of what is new. It is all new on every refresh. It does all of the data.