Forum Discussion
Grouping and frequency
jochendecraene , You have to create a table, you do not need this Switch. Table will have ranges like
0 2 0-2
3 5 <=5
Please find the attached file for the video after signature
Can you share sample data and sample output in a table format? Or a sample pbix after removing sensitive data.
jochendecraene , Not very clear. You need to create a bucket total at the client id level, using an independent table.
You can create a dynamic segmentation https://www.youtube.com/watch?v=CuczXPj0N-k
thnx for the quick response
i watched the video but I'm stuck in the beginning. I'll try to explain it more clearely in the image below.
jochendecraene , You have to create a table, you do not need this Switch. Table will have ranges like
0 2 0-2
3 5 <=5
Please find the attached file for the video after signature
Can you share sample data and sample output in a table format? Or a sample pbix after removing sensitive data.
Thank you for the help.
I'm not allowed to upload a pbix file in my profile, so here's a link to my one drive
The dataset goes over more than 1 year, so I should be able to filter by year
Thnx!!!
the dynamic segmentation worked. I forgot to summarize my ID's ... so I had nothing to segement 🙄