Forum Discussion

Arif270182's avatar
Arif270182
Helper II
7 years ago
Solved

Target Setting vs last year

Good Morning    I am looking for help in setting target number based on period filter with value of last year, below is my scenerio    I select date from 1st sep to 30th sep  i got 2 values day ...
Need Help
Show and Tell
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

     

    I think a bracket is missing.  Try this

     

    =-[Sales Diff]/((EOMONTH(TODAY(),0)-TODAY())+1)

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Not sure about data model. Assuming a usual data model, somthing like this below will help you.

 

CALCULATE( SUM(Sales_Fact[Sales]),SAMEPERIODLASTYEAR('Date'[Date])) - SUM(Sales_Fact[Sales])

 

Share some sample data, details about your model for more specific solution.

 

Thanks

Raj 

  • Arif270182's avatar
    Arif270182
    Helper II
    7 years ago

    Thats the table as you can see negative value is what i need to break in rest of the days 

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      You already have current and last year sales. so, simple SUM( sales[CYSales]) - SUM( Sales[LYSales]) should give you the expected result.

       

      Thanks

      Raj

      • Arif270182's avatar
        Arif270182
        Helper II
        7 years ago

        yeah i have already that value which is Sales Difference my point is i want to break that 2,294,091 divide by rest of days  based on filtered date.