Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Calculate Sales from start date

Need to calculate sales of a shop from start date of a shop. I have 2 tables : Sales and Date In Sales table I have information about volume of sales. In Date table I have shop start date. I have...
  • devanshi's avatar
    devanshi
    3 years ago

    Try this once,

    CALCULATE(SUM([Sales]), ALL(Tablename), [Startdate]>=MIN([Startdate]))

devanshi's avatar
devanshi
Icon for Helper V rankHelper V
3 years ago

Try this once,

CALCULATE(SUM([Sales]), ALL(Tablename), [Startdate]>=MIN([Startdate]))

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Any other way?

  • devanshi's avatar
    devanshi
    Icon for Helper V rankHelper V
    3 years ago

    If you have ID of shop or sales you can try this:

    Total Sales = CALCULATE(SUM([Sales]) ,
                                                 FILTER('Tablename', [SalesID] =  SELECTEDVALUE([SalesID]) && 
                                                                  [StartDate] = MIN[StartDate]                                                                                                        )
                                    )