Forum Discussion

KatkaS's avatar
KatkaS
Post Patron
6 years ago

DAX for text

Hello,

 

PLEASE what is the DAX function of returning the TEXT from another excel...?

 

I know SUMX for Value and I tried CONCATENATEX for Text, but it is returning strange values...

 

I have two separate excel sheets: one with Submitted reports, one with Approved reports.

And I'm creating new calculated column in Submitted and I would like to see in this column Text from Doc.Status column from Approved or zero, if the nothing is in the Approved sheet. Filter should be on FAM and PERIOD +1. 

 

Here is what I created, but the outcome is wrong..

Could someone help please?

 

Thank you!

 

 

Need Help

3 Replies

  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    Community Support
    6 years ago

    Hi KatkaS ,

     

    We create a sample and create a calculate column that you can refer.

     

    Column = 
VAR x =
    CALCULATE (
        MAX(Approved[value]),
        FILTER ( 'Approved', 'submitted'[Doc.Status] = 'Approved'[Doc.Status] )
    )
var y =
    CALCULATE(
           MAX(Approved[value]),
        FILTER ( 'Approved', 'submitted'[period + 1] = 'Approved'[period + 1] )
    )
var z =
    CALCULATE(
           MAX(Approved[value]),
        FILTER ( 'Approved', 'submitted'[FAM] = 'Approved'[FAM] )
    )
RETURN
     IF ( 
        LEN ( x ) > 0, x, 
        IF(
            LEN(y)>0,y,z))

     

    The result like this,

     

     

    If it doesn’t meet your requirement, could you please show the exact expected result based on the table that we have shared?

    BTW, pbix as attached.

     

    Best regards,

     

    Community Support Team _ zhenbw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • KatkaS's avatar
      KatkaS
      Post Patron
      6 years ago

      Hello v-zhenbw-msft  

       

      Thank you very much! I tried several times, but I didn't succeed..

      Is there a possibility that i sent you by pbix file for you to check where I make mistake...?

      Thank you!