Filter for Periods

[Kornholio]

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 for that period, but if chosing more that 1 period it would increase by 1. So if choice is period 1, then 60, if choice is period 1 and 2 then 120, etc. Is there a calculation that will do this?

[amitchandak]

@Kornholio 

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[Kornholio]

Spoiler

Hi,

So, I have fields...

Provider Name
Expectation
Units
Date
Status

So, each CSV file comes in to me for a period, say 03-01-20 to 3-14-20 is period 1, 03-15-20 to 03-31-20 is period 2. Each period is used as a filter option on the dashboard, so you can choose 1 or multiple periods. The Expectation during each period is 60 for each Provider Name. This is an expectation of Units to Expectation of 60 each period calculated. 

So, if the user chooses 1 period the Expectation is 60, but right now if the user chooses 2 periods, the Expectation stays at 60 but the units increase. I need the Expectation to show 60 for each Provider Name during each period, but if user chooses 2 or more periods, the Expectation needs to go up. So 2 periods =120 for Expectation

[v-chuncz-msft]

@Kornholio 

You may try ALLSELECTED and COUNTROWS to add a measure.

[Kornholio]

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.