table 'analytics.DeficitWithAmount'

	column id
		formatString: 0
		summarizeBy: sum
		isNameInferred
		sourceColumn: analytics deficit_proposal[id]

		annotation SummarizationSetBy = Automatic

	column scenario_id
		formatString: 0
		summarizeBy: sum
		isNameInferred
		sourceColumn: analytics deficit_proposal[scenario_id]

		annotation SummarizationSetBy = Automatic

	column group_name
		summarizeBy: none
		isNameInferred
		sourceColumn: analytics deficit_proposal[group_name]

		annotation SummarizationSetBy = Automatic

	column code
		summarizeBy: none
		isNameInferred
		sourceColumn: analytics deficit_proposal[code]

		annotation SummarizationSetBy = Automatic

	column place_month
		formatString: General Date
		summarizeBy: none
		isNameInferred
		sourceColumn: analytics deficit_proposal[place_month]

		variation Изменение
			isDefault
			relationship: 8120413a-959d-4c3b-ab8a-b244f0d75965
			defaultHierarchy: LocalDateTable_8f36e812-d721-465e-862e-5fd099a7c61e.'Иерархия дат'

		annotation SummarizationSetBy = Automatic

	column arrival_month
		formatString: General Date
		summarizeBy: none
		isNameInferred
		sourceColumn: analytics deficit_proposal[arrival_month]

		variation Изменение
			isDefault
			relationship: 583e0026-bdf5-4210-b1a3-abf75ac6ca64
			defaultHierarchy: LocalDateTable_ef722ff8-f6aa-45b8-910a-cceeaaab07a8.'Иерархия дат'

		annotation SummarizationSetBy = Automatic

	column demand_window_C
		summarizeBy: sum
		isNameInferred
		sourceColumn: analytics deficit_proposal[demand_window_C]

		annotation SummarizationSetBy = Automatic

		annotation PBI_FormatHint = {"isGeneralNumber":true}

	column projected_stock_at_T
		summarizeBy: sum
		isNameInferred
		sourceColumn: analytics deficit_proposal[projected_stock_at_T]

		annotation SummarizationSetBy = Automatic

		annotation PBI_FormatHint = {"isGeneralNumber":true}

	column order_qty
		summarizeBy: sum
		isNameInferred
		sourceColumn: analytics deficit_proposal[order_qty]

		annotation SummarizationSetBy = Automatic

		annotation PBI_FormatHint = {"isGeneralNumber":true}

	column updated_at
		formatString: General Date
		summarizeBy: none
		isNameInferred
		sourceColumn: analytics deficit_proposal[updated_at]

		variation Изменение
			isDefault
			relationship: 14187cae-2c10-49f9-9690-b7b6790691ee
			defaultHierarchy: LocalDateTable_412a89d8-5aff-45e5-aa52-1ff15a1aa314.'Иерархия дат'

		annotation SummarizationSetBy = Automatic

	column DeficitRub
		summarizeBy: sum
		isNameInferred
		sourceColumn: [DeficitRub]

		annotation SummarizationSetBy = Automatic

		annotation PBI_FormatHint = {"isGeneralNumber":true}

	column ManufacturerId
		formatString: 0
		summarizeBy: count
		isNameInferred
		sourceColumn: [ManufacturerId]

		annotation SummarizationSetBy = Automatic

	partition 'analytics.DeficitWithAmount' = calculated
		mode: import
		source =
				
				ADDCOLUMNS(
				    FILTER(
				        'analytics deficit_proposal',
				        'analytics deficit_proposal'[order_qty] > 0
				        && NOT(ISBLANK(RELATED('Номенклатура'[Цена учетная, руб])))
				    ),
				    "DeficitRub", 'analytics deficit_proposal'[order_qty] * RELATED('Номенклатура'[Цена учетная, руб]),
				    "ManufacturerId", LOOKUPVALUE('analytics manufacturers'[id], 'analytics manufacturers'[manufacturer], RELATED('Номенклатура'[Производитель]))
				    //"Code", 'analytics deficit_proposal'[code],
				    //"ScenarioId", 'analytics deficit_proposal'[scenario_id]
				)

	annotation PBI_Id = bcc81f59c0fe403c98e181c7419813bf