Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Sales by mounth from one table

Hi everyone,   I am new to the BI world, so excuse me if my question is poorly formulated and that the question might be simple.   I have created a Microsoft PowerApp in which various data are be...
Need Help
Tips and Tricks
MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

When you are refering that each value has it's own field I'm assuming that you have a column for each of the month (Jan2020,Feb2020,....Dec2020) correct?

 

You need to unpivot the months columns and then use a calendar table to wrap everything in your visuals, but without any data example or expected result is difficult to give you a better answer.

 

Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 (courtesy of @Greg_Deckler).

 

Regards,

MFelix

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I apologise for the poor description, as I said I am new to the program.

 

1. Your first assumption was right, each month has its own column.

 

I have unpivoted the Month columns, but the problem is I have other fields such as "WeightedRevenue", "CurrenBudget", which gets multiplied by the month that the project spans over. This is a picture of what I mean:

 

 

"MonthRevenue" is the pivoted column, however, notice that "Current Budget", "Weighted Revenue", etc gets multiplied

 

How can I provide the actual data so that it will be easier to understand what I am talking about?