Forum Discussion
amalgamate dates
I assume you have a date column in your dataset with some other fact data fields. If you want to group on Quarter level, you can user formula like "=ROUNDUP(MONTH([Date])/3, 0)" to get the quarter number of date, then you can just put the query field into visual so that the fact data will group on Quarter level automatically.
Regards,
It's simple if you have a dedicated date table. Does your data set have one?
prashantvarsani also try this custom visual
https://app.powerbi.com/visuals/show/Timeline1447991079100
Anonymous have you used it?
it saves lots of time - although it takes to much screen space? I wish they would reduce its size
Sean I have tried it twice but it never made it to the final report that I actually released. It seems to only be really useful on longer scopes of time than I usually deal in.