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
PoojaDarbhe's avatar
PoojaDarbhe
Icon for Resolver I rankResolver I
5 years ago

Hi Greg_Deckler , 

 

This is awsome technique, I am trying to implement it but getting following error, could you please guide me on this. All columns which I am trying to unpivot are of date type you can see it on the right side in fields.

 

 

Thanks in advance.

Regards,

Pooja Darbhe

  • 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().

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

      Hi Greg_Deckler 

       

      Thanks for the help, there was the problem with last line only.

       

      Regards,

      Pooja Darbhe

    • 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