Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
NickProp28
Post Partisan
Post Partisan

Perform target month data from excel

Dear  Community,

 

I have data pull from database to perform monthly revenue.
Problem is we have a montly target revenue that does not appear in DB, so its needed manually key in Excel and import to BI.

Isit possible to put under the same graph (Line 1 for DB revenue and Line 2 for Excel target revenue)? Moreover, each branch have different monthly target revenue.

NickProp28_0-1602219419000.png

This is target revenue assign to each branch.

 

Attached with the pbix file: https://ufile.io/e3g9ecfr

 

 

Appreciate and thanks for any help.

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@NickProp28 , The data you are showing, You should unpivot that in pover bi. So import data from excel , Unpivot

and join it with common date/month and branch dimesnion

https://radacad.com/pivot-and-unpivot-with-power-bi

You can create like this from date

Date = "01-" & [Month] & "-2020" // 2020 as i do not see year , you can use correct year

Change data type to date and join with date table.

 

 

First few min of this video can help:https://youtu.be/yPQ9UV37LOU

 

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.

 

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@NickProp28 , The data you are showing, You should unpivot that in pover bi. So import data from excel , Unpivot

and join it with common date/month and branch dimesnion

https://radacad.com/pivot-and-unpivot-with-power-bi

You can create like this from date

Date = "01-" & [Month] & "-2020" // 2020 as i do not see year , you can use correct year

Change data type to date and join with date table.

 

 

First few min of this video can help:https://youtu.be/yPQ9UV37LOU

 

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.

 

Dear @amitchandak ,

 

Thanks for your guide.

I have unpivot month and target. Added date on it. And have relationship between excel table with calendar table.

The problem that i having now is i cant link the excel table branch to DB table branch.

Can you kindly advice ?

NickProp28_0-1602227526798.png

 

Here the pbix: https://ufile.io/oa19ft16

 

Thanks for your time again.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.