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,
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?
Solved! Go to 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
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
Is that your source data and is that how it is formatted? I would suggest pivoting/upivoting it.
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.
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
Hi Dale, Thanks for your measure. Seemed to work with the following;
NextContactDateDay = ((Accounts[NextContactDate])<TODAY (), TODAY (), Accounts[NextContactDate])
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 |
---|---|
106 | |
105 | |
79 | |
68 | |
61 |
User | Count |
---|---|
143 | |
104 | |
103 | |
82 | |
70 |