Forum Discussion
bhelou
Responsive Resident
Responsive ResidentIf Condition ( text and value )
Dear , Kindly please correct me this measure in a column : ( it is returning the value of the text combined ReceivedIssued or RecievedReceived for the inventory ) Material_Status = IF ( ...
bhelou Something along the lines of:
Material_Status = SWITCH(TRUE(), XX_AWPT_MTL_MATERIAL_TRX[SOURCE_TYPE]= "Account alias" && XX_AWPT_MTL_MATERIAL_TRX[Net_Value]<0,"Issued", XX_AWPT_MTL_MATERIAL_TRX[SOURCE_TYPE]= "Account alias" && XX_AWPT_MTL_MATERIAL_TRX[Net_Value]>=0,"Received", XX_AWPT_MTL_MATERIAL_TRX[SOURCE_TYPE]="Inventory" && XX_AWPT_MTL_MATERIAL_TRX[Net_Value] <0,"Issued", XX_AWPT_MTL_MATERIAL_TRX[SOURCE_TYPE]="Inventory" && XX_AWPT_MTL_MATERIAL_TRX[Net_Value] >=0,"Received", "Unknown" )You can just keep tacking on logical conditions to your heart's content.
bhelouResponsive Resident
Responsive ResidentGreat it worked for 2 conditions , now i have multiple conditions in the source type : i tried the same with && it gave me for the purchase orders : Received from ProjectReceived
Material_Status =
IF(
XX_AWPT_MTL_MATERIAL_TRX[SOURCE_TYPE]= "Account alias",
IF(XX_AWPT_MTL_MATERIAL_TRX[Net_Value]<0,"Issued","Received"),
IF(XX_AWPT_MTL_MATERIAL_TRX[SOURCE_TYPE]="Inventory" && XX_AWPT_MTL_MATERIAL_TRX[Net_Value] <0,"Issued from Project","Received from Project"))
&
IF(
XX_AWPT_MTL_MATERIAL_TRX[SOURCE_TYPE] = "Purchase order",
IF(XX_AWPT_MTL_MATERIAL_TRX[Net_Value]<0,"Issued","Received"),
"Received"
)
Many Thanks Greg_Deckler
Greg_Deckler
Community Champion
Community Champion- bhelou
Okay ill try to use switch , Please can you show me a sample of my dax how to use it ?
Many Thanks Greg_Deckler
- Greg_Deckler
bhelou Something along the lines of:
Material_Status = SWITCH(TRUE(), XX_AWPT_MTL_MATERIAL_TRX[SOURCE_TYPE]= "Account alias" && XX_AWPT_MTL_MATERIAL_TRX[Net_Value]<0,"Issued", XX_AWPT_MTL_MATERIAL_TRX[SOURCE_TYPE]= "Account alias" && XX_AWPT_MTL_MATERIAL_TRX[Net_Value]>=0,"Received", XX_AWPT_MTL_MATERIAL_TRX[SOURCE_TYPE]="Inventory" && XX_AWPT_MTL_MATERIAL_TRX[Net_Value] <0,"Issued", XX_AWPT_MTL_MATERIAL_TRX[SOURCE_TYPE]="Inventory" && XX_AWPT_MTL_MATERIAL_TRX[Net_Value] >=0,"Received", "Unknown" )You can just keep tacking on logical conditions to your heart's content.
- bhelou
Thank you worked very good .
T