Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Hi Friends,
I am connecting power bi from snowflake views. i have multiple views being linclude with diffrent logic.
Below is the view input data.
I want to load and get below out put in PBI. Sum of Units :BoP,New,Exapansion,Contraction,Churn, EoP. 
What is the best way to this. I need exactly same as below. How to BoP as Same sort order.
What is the best approach if i have same kind of views for Payment,Suscription,Screeing .
Input VIEW.
| 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 | 
Solved! Go to Solution.
@Gopal_PV I am thinking that you create measures for BoP, New, Expansion, etc. and then in a Matrix visual you turn on "Switch values to rows":
You can create a sorting table, than link the table, than use the data from the sort table.
Example:
1. Create table and sort by sort number
2. Than link table
3. use the value from Sort table rather than main:
@Gopal_PV I am thinking that you create measures for BoP, New, Expansion, etc. and then in a Matrix visual you turn on "Switch values to rows":
 
					
				
				
			
		
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
 
            | User | Count | 
|---|---|
| 80 | |
| 49 | |
| 35 | |
| 31 | |
| 30 |