cancel
Showing results for
Did you mean:
Frequent Visitor

## Generating data for months from quarter

Hi,

I use PBI Desktop live connection to SSAS and in my data model I have table :

User          Time (Quarter)                            Time (Month)                      Amount USD Quarter

 aaa 2018Q1 01.04.2018 90 bbb 2018Q2 01.07.2018 150 ccc 2018Q3 01.10.2018 300

Amount USD Quarter is paid when Quarter are end.

I need to calculate part Amount USD for all months this Quarter like this :

User                Time (Quarter)                      Time (Month)                         Amount USD Quarter

 aaa 2018Q1 01.01.2018 30 aaa 2018Q1 01.02.2018 30 aaa 2018Q1 01.03.2018 30 bbb 2018Q2 01.04.2018 50 bbb 2018Q2 01.04.2018 50 bbb 2018Q2 01.06.2018 50 ccc 2018Q3 01.07.2018 100 ccc 2018Q3 01.08.2018 100 ccc 2018Q3 01.09.2018 100

Maybe there is a way to calculate 1/3 Amount USD Quarter for a given month of the quarter in DAX?

How I can generate a details for months?

Thanks

3 REPLIES 3
Super User

## Re: Generating data for months from quarter

If you can use a composite model, one way might be to create an Enter Data query like this:

MonthTable

Time (Quarter), Time(Month)

2018Q1,01.01.2018

2018Q1,01.02.2018

2018Q1,01.03.2018

...

Create a relationship on Time (Quarter) to your original table.

Now, create a measure like this (calling your original table "Table":

Measure = SUM([Amount USD Quarter])/3

### I have book! Learn Power BI from Packt

Proud to be a Datanaut!

Super Contributor

## Re: Generating data for months from quarter

Hi @roome,

Which data source did you connect to? Tabular or Multidimensional?

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor

## Re: Generating data for months from quarter

Hi Yuliana,

I use tabular model.

Announcements

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 40 members 1,012 guests
Recent signins: