Forum Discussion
Accumulated Histogram from Classes obtained by Measures
Hi dear community,
I would like to rank the amount of visits a customer makes to a store and group the results into a histogram.
Imagine the following example:
Client Visit
aaa 01/01/2021 10:00
aaa 02/01/2021 09:00
aaa 02/01/2021 20:00
This should output:
If 01/01/2021 is selected: "one visit"
If 02/01/2021 is selected: "two visits"
If no date is selected: "> two visits".
And I would like to reflect this in a bar chart (imagine several clients)
ex:
|
| |
| | |
One visit two visits > two visits
Thank you for your help,
Simao
This post of @v-juanli-msft (link) solved the problem. Thanks anyway
3 Replies
- amitchandak
Super User
Anonymous , if you have datetime column create a seperate date column and join with a date table
Date = [datetime].date
or
Date = date(year([datetime]),month([datetime]),day([datetime]))Create a measure like
Cumm= CALCULATE(distinctcount(Table[Date]),filter(allselected(date),date[date] <=max(date[Date])))
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
This post of @v-juanli-msft (link) solved the problem. Thanks anyway
