Forum Discussion
Kornholio
6 years agoHelper III
Filter for Periods
I have a CSV file that comes in, it has a 2 week period of working minutes of people working in different statuses. Each time i bring in a new 2 week period i need the Expectation to stay the same fo...
v-chuncz-msft
6 years agoCommunity Support
Kornholio
6 years agoHelper III
hi, so i have a csv file that is updated every two weeks. For example first file is for date range 1-1-20 to 1-14-20, it only has date column called Target Date, which is between those dates above. Then second file comes is from 1-14-20 to 1-21-20, dsmr Target Date column with those dates. Then the third, fourth, etc are two week periods coming in. How do i update the Power BI to take in each new csv file with the additional dates or periods in this case? I want it to fetch the newest file and then add to the dashboard the new information.