I have a
And established a relation based on date columns in these two tables.
I want to calculate
Then place these counts in day buckets which is:
I am able to do the count part but not days bucket correctly.
E.g.: Selected MonthEnd from filter is 31/01/2020.
0 - 30 days
31 - 90 days
91 - 180 days
181 - 365 days
12 - 18 mths
18 mths - 2 yrs
2 yrs +
Part of it is already covered in my blog. How to deal with start and end date
For date bucket
maxx(summarize(Table,table[Caseid],"_diff", datediff(mix(table[start date]),max(Date[Date]))),
_diff <=30 , "0 - 30 days",
_diff >30 && _diff<90, "31 - 90 days",
_diff >91 && _diff<180, "91 - 180 days",
_diff >181 && _diff<356, "181 - 365 days",
_diff >365 && _diff<365+180, "12 - 18 mths",
_diff >365 && _diff<365+365, "18 mths - 2 yrs",
"2 yrs +"
Row context is important
Proud to be a Super User!
The solution you have provided for the measure only works for CaseId having the ReservedOutcomeDate in current month.
For CaseId having ReservedOutcomeDate before the selected month, the bucket is blank.
Can you have a look or paste an updated pbix file. I am attaching my version of the file.
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.