Forum Discussion
Control the data imported by another table
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.
I realized that your Date column you're trying to filter on is in number format. You will need to either change it to a date or create a date column using the Query Editor. You can easily acheive this by clicking Column from Examples and then typing the date format of one of your rows. For example, if the date key is 06252018 you can type 06/25/2018 and it will create a new column with proper dates. When you have this new column, use a date filter like such:
Click on Equals and set the date equal to literally any date you want. Then follow the steps outlined above!
I changed the datekey, it give a error , since it is not date, the datekey joined with another datekey in Date_Dim table, then you can get teh day.
you mean i should type the date fromat i want to my datekey, i did, it gives me: