Forum Discussion

o59393's avatar
o59393
Icon for Post Prodigy rankPost Prodigy
6 years ago

Histogram

hi all   I have 1400 rows containing a department time in days. I would like to have a histogram that divides in groups of 30 days. (0 to 1 months, 1 to 2 months) etc.   Once it reaches 8 months,...
Need Help
Show and Tell
o59393's avatar
o59393
Icon for Post Prodigy rankPost Prodigy
6 years ago

hi dax

 

Is there a way to create a dax formula without using M code? It's ok if it without the >8, it can be in groups by 30 days.

 

Thanks!

dax's avatar
dax
Icon for Community Support rankCommunity Support
6 years ago

Hi o59393,

I am not clear about your requirement, did you want to create a column which like below?

Column = ROUND(report1576508921493[Department Time]/30,0)

If not, please correct me and inform me your expected output, then I will help you more correctly.

 

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.