Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
7 years ago

DAX Unpivot

At a recent user group meeting in Columbus Ohio, one of my members presented me with a problem they were having. The member was working with a SharePoint list and attempting to unpivot a number of co...
Other
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

PoojaDarbhe - I can't see all of the formula so not sure exactly where you are getting the error in your DAX. If we are talking about the last line in your screen shot, you could try to replace "" with BLANK().

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Greg_Deckler,

 

I have same error message as@PoojaDarbhe , i tred to change "" to (), then i got another error as below, please help, thanks. 

changed "" to () as suggested but got another error as below

 

 

  • PoojaDarbhe's avatar
    PoojaDarbhe
    Icon for Resolver I rankResolver I
    5 years ago

    Hi Anonymous 

     

    Write Blank(), that will solve your problem.

    Let me know in case of any issues.

     

    Best regards,

    Pooja Darbhe

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi PoojaDarbhe,

      Did that but got the below error message, please help, thanks.

      • PoojaDarbhe's avatar
        PoojaDarbhe
        Icon for Resolver I rankResolver I
        5 years ago

        Hi Anonymous ,

         

        Instead of [Output All] write [Outputfg], it should be column name not the value.

         

        Please try this and let me know if that works.

         

        Best regards,

        Pooja Darbhe