Forum Discussion

prashantvarsani's avatar
prashantvarsani
New Member
9 years ago
Solved

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?
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    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,

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

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,