Forum Discussion
Cumulative Count
I just dropped the three measures into a bar chart and got this:
Is that not what you want?
I don't think you can use SWITCH like that as you want someone hired 1 day ago to appear in the 30, 60 and 90 day bucket. SWITCH puts it in one bucket only, not multiple.
Try multiple measures. For example:
Hired Last 30 Days =
CALCULATE(
COUNT('Hire Dates'[Hired Days Ago]),
FILTER('Hire Dates','Hire Dates'[Hired Days Ago] <= 30)
)Hired Last 60 Days =
CALCULATE(
COUNT('Hire Dates'[Hired Days Ago]),
FILTER('Hire Dates','Hire Dates'[Hired Days Ago] <= 60)
)Etc. Drop those measures in a table.
IS that what you are looking for?
edhans This calculation would give the right answer but I would not get an appropriate bar chart hat shows me those values right?
I want the axis to show "LAst 30 Days", "LAst 60 Days", "Last 90 Days" and the values are those which are calcualted as you mentioned
I just dropped the three measures into a bar chart and got this:
Is that not what you want?
If that is not what you want, look at this file and then tell me how you would want it to be and why the 3 measures (30/60/90) aren't working for you correctly. I'll check back in in an hour or so, or someone else could jump in with the solution you are seeking.
edhans Hey this works! thank you.
Great Anonymous - glad my idea helped.