Create minimum table

[Anonymous]

Hi 

I need your help to resolve this query. I want to create this table in minimal way . Here, need to create 15 table as per this requirement. Is it possible to create, minimal no. of table in SSAS model to make relationship for PBI reporting.

Thanks,

Varsri

[Anonymous]

Hi Greg

Thanks for giving suggestion. I hope ,now will be more feasible to understand in given table. I want to create this table in minimal way . Here, need to create 15 table as per this requirement. Is it possible to create, minimal no. of table in SSAS model to make relationship for PBI reporting.

Target Category                 Target for                         Target on
IMS                                     Customer                          SKU
IMS                                     Customer                          Product Group
IMS                                     Customer                          Total
IMS                                     Employee                          SKU
IMS                                     Employee                          Product Group
IMS                                     Employee                          Total
IMS                                    Organization                      SKU
IMS                                    Organization                      Product Group
IMS                                    Organization                      Total
Shipment                           Depo                                  SKU
Shipment                           Depo                                  Product Group
Shipment                           Depo                                  Total

Shipment                           Organization                      SKU

Shipment                           Organization                      Product Group

Shipment                           Organization                      Total

Thanks,

Varsri

[Greg_Deckler]

@Anonymous Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, 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

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.