Forum Discussion

Brookied's avatar
Brookied
Icon for Helper I rankHelper I
5 years ago
Solved

DAX help needed

Afternoon All,  I need a little help to get the below working as expected.     I have a table of income data,  this would inclusde Amount = Various values Payment Date = date of payment  Source...
Need Help
Show and Tell
Tutorial Requests
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    Brookied 

    have you tried

    IF(LEFT(SOUCECODE,1)="A" && NOT SOURCECODE IN {"XXX","XXX","XXX"}&&LEFT(SOURCECODE,2)<>"AV", "01_CASH")

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
5 years ago

Brookied 

have you tried

IF(LEFT(SOUCECODE,1)="A" && NOT SOURCECODE IN {"XXX","XXX","XXX"}&&LEFT(SOURCECODE,2)<>"AV", "01_CASH")

  • Brookied's avatar
    Brookied
    Icon for Helper I rankHelper I
    5 years ago

    ryan_mayu 

    I have not so let me rebuild based on above syntax and will let you know,   Thanks