Next available date

[Anonymous]

Hi Team,

Need your help in creating a measure to select only next available date(highlighted in yellow) from column "Next upload" depending on the date in column "Last upload". Dates will change depending on the dump.

Thanks and regards

Abhijit

[Anonymous · Accepted solution]

Hi All,

I am able to solve this issue.

Here is the code:

Next Upload Date =
var currentDate = TODAY()
var currentSF = MAX(Merge1[Data Sourcing Details])
return
CALCULATE(MIN(Merge1[Next Upload]),FILTER(ALL(Merge1),Merge1[Data Sourcing Details]=currentSF&&Merge1[Next Upload]>=TODAY()))

Regards

Abhijit

[Greg_Deckler]

Can you explain this a little bit? I'm not clear on what exactly the relationship between last date and next available date is. 

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

Hi @Greg_Deckler,

I am creating a new consolidate view where I just need immediate next date from Column "Next Upload" based on the date from "Last upload".

Here is the view:

Thanks

Abhijit

[v-shex-msft]

Hi @Anonymous,

Can you please share some sample data/pbix file for test and code formula? You can upload to onedrive or google drive and share file link here.

Regards,

Xiaoxin Sheng