Include data from previous date into current date

[dant05]

Hi, 

I currently have data in a previous 'Next Contact Date' field. I would now like to include all data from the 'Next Contact Date' field, where the next contact date is in the past, into today's date or the most current date. 

Can anybody help?

[v-jiascu-msft]

Hi @dant05,

How to include? Add up? Or count, etc. ? Please follow @Greg_Deckler's suggestion tidy up the data first. If you need more support, please share a dummy sample in the original format and the expected result.

Best Regards,

Dale

[Greg_Deckler]

Is that your source data and is that how it is formatted? I would suggest pivoting/upivoting it.

[dant05]

The next contact data is from my source data. I'm new to Power BI but would need it to do;

If (Accounts[NextContactDate]) is before today's date then return todays date. 

[v-jiascu-msft · Accepted solution]

Hi @dant05,

Can you share the source data? We didn't see any NextContactDate here. The formula could be like below.

Measure =
IF (
    MIN ( Accounts[NextContactDate] ) < TODAY (),
    TODAY (),
    Accounts[NextContactDate]
)

Best Regards,

Dale

[dant05]

Hi Dale, Thanks for your measure. Seemed to work with the following;

NextContactDateDay = ((Accounts[NextContactDate])<TODAY (), TODAY (), Accounts[NextContactDate])