Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
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
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
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
User | Count |
---|---|
93 | |
83 | |
77 | |
71 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |