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

Hi Tom..

 

silly question how do you attcahed a pbix file here....i can send a drop box link?

  • TomMartens's avatar
    TomMartens
    Super User
    7 years ago

    Hey,

     

    just post the dropbox link!

     

    regards,

    Tom

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Link

       

      1. the data in the link file you#ll need to chnage table name to dimdate and add a date hierarchy to the sales table....

       

      also i have managed to get t his far - but the measure only gives me the current period 12 months rolling...

      2. i want to show two visuals one in a clustered bar chart showing the previous 12 period and secondaly a card that dynamically changes to reflect the current month only...

       

      Datefilter12Month =
VAR MonthsToLookBack = 12
VAR DataTableDate =
    MAX ( 'DimDate'[Date] )
RETURN
    CALCULATE (
        SUM ( Sales[Sales] );
        DATESINPERIOD ( dimDate[Date]; DataTableDate; - MonthsToLookBack; MONTH )
    )
      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Link

         

        Here is a new pbix...that uses the dax. Sorry had trouble uploading file..Apologies.