Forum Discussion
Control the data imported by another table
Hello, I have a sales table, which include all inforamtion of my orders. But in this table, there is now datetime field, we have a column called REQUESTED_DATE_KEY wihch is number format. ...
Hey NoobAnalyst01
Since you probably want to keep your full Sales table for other use I would do the following:
- Duplicate your Sales table
- Filter the duplicated table down to Today
- To do this, Use the date filter setting on the dropdown of the field
- Set it to an arbitrary date
- Open up the advanced editor and replace the date with DateTime.LocalNow()
- Then perform your merge
Hope this helps,
Parker
Hello,
Parker, what do you mean by:
- To do this, Use the date filter setting on the dropdown of the field
- Set it to an arbitrary dat
Sorry, i am new to power bi, i didn;t get your method.