Thursday, August 15, 2019

Power BI - Column to calculate Type Descriptions - Convert from int option value to description

DocTypeDesc = switch(FORMAT('32ItemLedgerEntry'[Document Type],"#"),"0","",
FORMAT('32ItemLedgerEntry'[Document Type],"#"),"1","Sales Shipment",
FORMAT('32ItemLedgerEntry'[Document Type],"#"),"2","Sales Invoice",
FORMAT('32ItemLedgerEntry'[Document Type],"#"),"3","Sales Return Receipt",
FORMAT('32ItemLedgerEntry'[Document Type],"#"),"4","Sales Credit Memo",
FORMAT('32ItemLedgerEntry'[Document Type],"#"),"5","Purchase Receipt",
FORMAT('32ItemLedgerEntry'[Document Type],"#"),"6","Purchase Invoice",
FORMAT('32ItemLedgerEntry'[Document Type],"#"),"7","Purchase Return Shipment",
FORMAT('32ItemLedgerEntry'[Document Type],"#"),"8","Purchase Credit Memo",
FORMAT('32ItemLedgerEntry'[Document Type],"#"),"9","Transfer Shipment",
FORMAT('32ItemLedgerEntry'[Document Type],"#"),"10","Transfer Receipt",
FORMAT('32ItemLedgerEntry'[Document Type],"#"),"11","Service Shipment",
FORMAT('32ItemLedgerEntry'[Document Type],"#"),"12","Service Invoice",
FORMAT('32ItemLedgerEntry'[Document Type],"#"),"13","Service Credit Memo",
FORMAT('32ItemLedgerEntry'[Document Type],"#"),"14","Posted Assembly"
)

No comments:

Post a Comment