61 lines
2.0 KiB
Plaintext
61 lines
2.0 KiB
Plaintext
table 'Retail.Export.KPI'
|
|
lineageTag: db1bdf81-3ec1-462e-9200-8bd2d9d87af0
|
|
|
|
column 'Retail.Export.KPI'
|
|
lineageTag: d9793609-4258-4f09-a65c-cc373e3d0d5b
|
|
summarizeBy: none
|
|
sourceColumn: [Value1]
|
|
sortByColumn: 'Retail.Export.KPI 个订单'
|
|
|
|
relatedColumnDetails
|
|
groupByColumn: 'Retail.Export.KPI 个字段'
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column 'Retail.Export.KPI 个字段'
|
|
isHidden
|
|
lineageTag: bf4987e9-6657-44cb-a494-5d3d1cfefce8
|
|
summarizeBy: none
|
|
sourceColumn: [Value2]
|
|
sortByColumn: 'Retail.Export.KPI 个订单'
|
|
|
|
extendedProperty ParameterMetadata =
|
|
{
|
|
"version": 3,
|
|
"kind": 2
|
|
}
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column 'Retail.Export.KPI 个订单'
|
|
isHidden
|
|
formatString: 0
|
|
lineageTag: 8db2c899-88f0-4e26-8ec2-6c3cf8c843a1
|
|
summarizeBy: sum
|
|
sourceColumn: [Value3]
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
partition 'Retail.Export.KPI' = calculated
|
|
mode: import
|
|
source =
|
|
{
|
|
("GR%", NAMEOF('Measure'[Retail.Export.Gr%]), 0),
|
|
("MS%", NAMEOF('Measure'[Retail.Export.MS%]), 1),
|
|
("ΔMS%", NAMEOF('Measure'[Retail.Export.ΔMS%]), 2),
|
|
("Sales", NAMEOF('Measure'[Retail.Export.Sales]), 3),
|
|
("Top1 Brand.Gr%", NAMEOF('Measure'[Retial.Export.Top1Brand.Gr%]), 4),
|
|
("Top1 Brand", NAMEOF('Measure'[Retial.Export.Top1BrandName]), 5),
|
|
("Top1 Incr.Gr%", NAMEOF('Measure'[Retial.Export.Top1incrementalBrand.Gr%]), 6),
|
|
("Top1 Incr.Brand", NAMEOF('Measure'[Retial.Export.Top1incrementalBrandName]), 7),
|
|
("Top2 Brand.Gr%", NAMEOF('Measure'[Retial.Export.Top2Brand.Gr%]), 8),
|
|
("Top2 Brand", NAMEOF('Measure'[Retial.Export.Top2BrandName]), 9),
|
|
("Top2 Incr.Gr%", NAMEOF('Measure'[Retial.Export.Top2incrementalBrand.Gr%]), 10),
|
|
("Top2 Incr.Brand", NAMEOF('Measure'[Retial.Export.Top2incrementalBrandName]), 11)
|
|
}
|
|
|
|
annotation PBI_Id = 832482db9e694291a671880bfecb20b5
|
|
|
|
annotation TabularEditor_TableGroup = 01_ParameterField
|
|
|