cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
roome Frequent Visitor
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

aaa2018Q101.04.201890
bbb2018Q201.07.2018150
ccc2018Q301.10.2018300

 

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

aaa2018Q101.01.201830
aaa2018Q101.02.201830
aaa2018Q101.03.201830
bbb2018Q201.04.201850
bbb2018Q201.04.201850
bbb2018Q201.06.201850
ccc2018Q301.07.2018100
ccc2018Q301.08.2018100
ccc2018Q301.09.2018100

 

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

3 REPLIES 3
Super User
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


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

Proud to be a Datanaut!

v-yulgu-msft Super Contributor
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.
roome Frequent Visitor
Frequent Visitor

Re: Generating data for months from quarter

Hi Yuliana,

I use tabular model.

 

Regards Adam

Helpful resources

Announcements
Virtual Launch Event

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

Power BI Helps Homeless and Trouble Youth

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

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 40 members 1,012 guests
Please welcome our newest community members: