topic Re: Calculate Sales from start date in DAX Commands and Tips

Calculate Sales from start date

Anonymous — Tue, 20 Jun 2023 11:00:53 GMT

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 tried to use that code:

SWS comp = CALCULATE(Sales[sales], [Start Date] >= [Start Date])

Re: Calculate Sales from start date

devanshi — Tue, 20 Jun 2023 11:12:59 GMT

Total Sales =
VAR startdate = FIRSTDATE([Startdate])
CALCULATE(SUM([Sales]) , [Startdate] >= startdate)

Re: Calculate Sales from start date

Anonymous — Tue, 20 Jun 2023 11:19:00 GMT

There is an issue with syntax

Re: Calculate Sales from start date

devanshi — Tue, 20 Jun 2023 11:31:17 GMT

Try this once,

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

Re: Calculate Sales from start date

Anonymous — Wed, 21 Jun 2023 04:38:13 GMT

Any other way?

Re: Calculate Sales from start date

devanshi — Wed, 21 Jun 2023 04:56:15 GMT

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] )
)