Forum Discussion

MStark's avatar
MStark
Icon for Helper III rankHelper III
3 years ago

Duplicate data on Files - Take most recent Data

Hi,   We have data saved in a file daily with Sales amounts per day for the past 14 days. Each day there might be some updates done to previous days which is why we pull for the past 14 days instea...
Need Help
mussaenda's avatar
mussaenda
Icon for Community Champion rankCommunity Champion
3 years ago

Hi MStark,

 

is it only one file and you are adding the data?

If that is the case, we can simply put a dynamic filter like this

 

So everytime you will have a new data, the power bi will automatically filter your data.

Instead of declaring a static dates.

 

Hope this helps

Thanks

  • MStark's avatar
    MStark
    Icon for Helper III rankHelper III
    3 years ago

    Unfortunatly not. As said in the example, each day a file with the previes 15 days data gets saved