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,

 

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.

  • TomMartens's avatar
    TomMartens
    Super User
    7 years ago

    Hey,

     

    wondering if you read my last post carefully:

     

    I will not download any file that that someone made available via direct message or that I have to delete on a certain condition, e.g. providing a solution.

     

    Regards,

    Tom

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Apologies...Timing.

       

      Just send private message...sorry

  • TomMartens's avatar
    TomMartens
    Super User
    7 years ago

    I deleted your private message without downloading

     

    Cheers,

    Tom

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Can you confirm receipt. Also from the table that does not have sales date you'll  need to create a month and year column to that data set. Or the sales table data set. Also as I was in a rush to create a sample file did not have time to label tables correctly- sorry.

       

      The measure needs to calculate the sum of sales 12 months back from the selected date correct? Based on two slicers  year and month..dynamically