Forum Discussion
update data and filter by date
Hi, i am new here. I have two questions: how can i filter my data by date?, how can i update the data daily? (i get the data from a multidimensional cube) regards.
You will more than likely need a date table. Once you have a date table configured, you will write many of the time functions into your dax and filter them using the date table in slicers or in calculations. Here is a good link to get you started with dates.
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-quickstart-learn-dax-basics/
If you can provide a sample of your data and data model with specific questions, we can offer better assistance.