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. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Do you want to divide the difference by the remaining days in sep and display under CY sales column? can you please explain... also can you put the expected result in table format for better understanding?

         

        Thanks

        Raj