Generating data for months from quarter

[roome]

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 

Adam

[Anonymous]

Hi was this issue ever resolved. This is exactly the problem I've got and can't find a solution anywhere. Thanks in advance

[v-yulgu-msft]

Hi @roome,

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

Regards,

Yuliana Gu

[roome]

Hi Yuliana,

I use tabular model.

Regards Adam

[Greg_Deckler]

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