Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Dax formula error

Hi experts   I have the following DAX formula.....which do not work with certain visuals...but work with others. i am trying to work out the previous 12 months based on a selected year and month fi...
Need Help
TomMartens's avatar
TomMartens
Super User
7 years ago

Hey,

 

it would be helpful if provide the error message as well :-)

 

Looking at you code I see that both of

return (s)

are not nested, I guess that this is reponsible for the error.

 

Hopefully this answers your question, if not please consider to create a pbix file with sample data, upload the file to onedrive or dropbox and share the link.

 

Regards,

Tom

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Tom...

     

    Sorry cannot do, ill get killed if i upload a file... and to re create it going to take for every......not sure what you mean by nested,,

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Also the there are two measures there just posted into once "insert Code" scereen..

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    Hi Tom

    Is I upload a file can you delete it after the solution?
    • TomMartens's avatar
      TomMartens
      Super User
      7 years ago

      Hey,

       

      I'm sorry I got confused by the two measures in one code screen, sorry for that.

       

      Please consider to create sample data, just an Excel file and a PBIX file. I will not download any file that I have to delete after I find a solution (if I ever will) or that you provide via a direct message.

       

      Regards,

      Tom

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        I'll send drop box link via private message.