Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |