60 lines
1.7 KiB
Plaintext
60 lines
1.7 KiB
Plaintext
table RetailExport
|
|
lineageTag: 1c033c42-dc43-4150-a71d-8c3776b33af5
|
|
|
|
column RetailExport
|
|
lineageTag: e67ee0a0-3fc6-49f8-a42d-070129dacd48
|
|
summarizeBy: none
|
|
sourceColumn: [Value1]
|
|
sortByColumn: 'RetailExport 个订单'
|
|
|
|
relatedColumnDetails
|
|
groupByColumn: 'RetailExport 个字段'
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column 'RetailExport 个字段'
|
|
isHidden
|
|
lineageTag: 85cbfe81-6c1b-4db0-a908-f42bb3e6ab96
|
|
summarizeBy: none
|
|
sourceColumn: [Value2]
|
|
sortByColumn: 'RetailExport 个订单'
|
|
|
|
extendedProperty ParameterMetadata =
|
|
{
|
|
"version": 3,
|
|
"kind": 2
|
|
}
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column 'RetailExport 个订单'
|
|
isHidden
|
|
formatString: 0
|
|
lineageTag: f586d247-7667-4416-8618-20c7c8acbc9b
|
|
summarizeBy: sum
|
|
sourceColumn: [Value3]
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
partition RetailExport = calculated
|
|
mode: import
|
|
source =
|
|
{
|
|
("Brand", NAMEOF('Fact_Retail_RawData'[brand]), 0),
|
|
("Molecule", NAMEOF('Fact_Retail_RawData'[common_name]), 1),
|
|
("Corp", NAMEOF('Fact_Retail_RawData'[corp]), 1),
|
|
("Corp Type", NAMEOF('Fact_Retail_RawData'[corp_type]), 3),
|
|
("Corporation", NAMEOF('Fact_Retail_RawData'[corporation]), 2),
|
|
("Rank", NAMEOF('Fact_Retail_RawData'[RANK]), 0),
|
|
("Rx/OTC", NAMEOF('Fact_Retail_RawData'[product_type]), 6),
|
|
("Brand Desc", NAMEOF('Fact_Retail_RawData'[product_desc]), 7),
|
|
("DTP", NAMEOF('Fact_Retail_RawData'[dtp_name]), 8),
|
|
("TA", NAMEOF('Fact_Retail_RawData'[TA]), 9),
|
|
("RC", NAMEOF('Fact_Retail_RawData'[RC]), 10)
|
|
}
|
|
|
|
annotation PBI_Id = f49375727db0477e9fc1d3349d328db5
|
|
|
|
annotation TabularEditor_TableGroup = 01_ParameterField
|
|
|