The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi Folks,
I have a view from snowflake datamart source. i have requirement create a unpivot columns and details table to display those units. do i need to load a duplicate view the different name or How to achive the output with below intput data. can you please help me in this.
Inputdata:
Units View | |||||||||||
YEAR | MONTH | ACCOUNTID | NAME | BEGINNING_OF_PERIOD_UNITS | NEW_UNITS | EXPANSION_UNITS | CONTRACTION_UNITS | CHURN | END_OF_PERIOD_UNITS | DISCREPANCY | |
2020 | 5 | 13 | Netflix | 0 | 3 | 0 | 0 | 0 | 3 | 0 | |
2020 | 5 | 14 | Hotstar | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
2020 | 6 | 13 | Prime | 3 | 0 | 16 | 0 | 0 | 19 | 0 | |
2020 | 6 | 14 | Voot | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
2020 | 7 | 13 | Youtube | 19 | 0 | 0 | 0 | 0 | 19 | 0 | |
2020 | 7 | 14 | Sony | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
2020 | 8 | 13 | Aha | 19 | 0 | 1 | 0 | 0 | 20 | 0 | |
2020 | 8 | 14 | Mx Player | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Output Repot Needed in Power BI Desktop: I have unpivot below columns and Values
One Matrix View: Beging of Period,New,Expansion,Contraction, Churn, EoP
Account Name Wise Beging of Period,New,Expansion,Contraction, Churn, EoP
I have loaded another same view with other name to use in below . is this correct way to do this to load same view.
is there any other way to achive this.
Hi @Gopal_PV ,
Just checking in were you able to implement the steps shared by super user and test the model changes? Did the visuals start showing the correct year-wise counts once aligned with the Date table? Let us know how it went, and we can help fine-tune further if you still see gaps.
Regards,
Akhil.
Hi @Gopal_PV ,
Thanks a lot, @speedramps for your detailed and insightful solution – really appreciate the way you've broken it down. @Gopal_PV the steps shared by the Super User should work in this way. [Briefly summarize how the solution works – e.g., "By restructuring your data model and aligning it with the Date table, you’ll get the correct year-wise customer counts across your visuals."]. Please try implementing it as guided above. Let us know if this worked on your side or if you're still seeing any issues, happy to help further if needed.
Thanks,
Akhil.
Hi @Gopal_PV
Power BI is 10 years old today. Happy Birthday !
Try this ....
Import your data and edit it In Power Query
Add a Date column
Date = Text.Combine({"01/0", Text.From([MONTH], "en-GB"), "/", Text.From([YEAR], "en-GB")})
Remove unneeded columns
Click on the Date column and in the Transform menu > Unpivot >Unpivot other columns
Create a matrix visual
I assume that you then have the basic skills to rename the columns and make the report pretty
Please click thumbs up and [accept solution]. Thank you ! 😎