Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
prashantvarsani
New Member

amalgamate dates

 Hi,

 

I am trying to group data in Quarterly periods from the dates on my data set instead of having the total numbers by indivudal days. Is this possible on Power BI?

1 ACCEPTED SOLUTION
v-sihou-msft
Employee
Employee

@prashantvarsani

 

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,

View solution in original post

4 REPLIES 4
v-sihou-msft
Employee
Employee

@prashantvarsani

 

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,

KHorseman
Community Champion
Community Champion

It's simple if you have a dedicated date table. Does your data set have one?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Sean
Community Champion
Community Champion

@prashantvarsani also try this custom visual

 

https://app.powerbi.com/visuals/show/Timeline1447991079100

 

@KHorseman have you used it?

 

it saves lots of time - although it takes to much screen space? I wish they would reduce its size

KHorseman
Community Champion
Community Champion

@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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors