topic Re: Sum between two dates in Desktop

Sum between two dates

Anonymous — Tue, 10 Mar 2020 20:16:47 GMT

Hi,

In one of my reports I use TOTALMTD to give the monthly values of that month. However I need a daxformula that summarize a value between two dates (will be a static number throughout the report.) but I can't seem to get it to work.

I want to calculate the number of bus salesmen between the dates 2019/02/01-2019/02/28.

I have created a calendar table as well that I use for my TOTALMTD. Does anyone know why it does not work?

Re: Sum between two dates

az38 — Wed, 11 Mar 2020 06:07:54 GMT

hi Anonymous

try without filter and use more appropriate date statement, like

= CALCULATE( SUM(ddd[RT Bus Salesmen]); DATESBETWEEN(ddd[Date];DATE(2019;2;1); DATE(2019;2;28)) )

Re: Sum between two dates

v-kelly-msft — Wed, 30 Jun 2021 10:04:42 GMT

Hi @Oscar1133 ,

Here are 2 measures that can satisfy your need:

Test bus salesmen=CALCULATE(SUM(ddd[RT Bus Salesmen]),DATESBETWEEN('Calendar table'[Date],DATE(2019,02,01),DATE(2019,02,28)))

Test bus salesmen=CALCULATE(SUM(ddd[RT Bus Salesmen]),FILTER(ALLSELECTED('Calendar table'),'Calendar table'[Date]>=DATE(2019,02,01) && 'Calendar table'[Date]<=DATE(2019,02,28)))

Saludos
Kelly

Did I answer your question? Mark my position as a solution!

Re: Sum between two dates

Syndicate_Admin — Thu, 04 Mar 2021 01:16:53 GMT

Hi, I'm starting with Powr BI and I'm getting to know the DAX features.

I'd like to know if there's a way to do the following with DAX.

I have a table with the following data:

Team	Origin	Destination	Departure Date	Arrival Date	Distance kms	Total Distance
T1	Planta1	Almacen1	01/03/2021 02:01	01/03/2021 10:01	150	292
T1	Almacen1	Planta1	01/03/2021 11:10	01/03/2021 19:01	142
T1	Planta1	Almacen2	02/03/2021 03:01	02/03/2021 12:01	210	420
T1	Almacen2	Planta1	02/03/2021 13:10	02/03/2021 22:01	210
T1	Planta1	Bodega1	03/03/2021 02:01	03/03/2021 02:31	7	299
T1	Bodega1	Almacen1	03/03/2021 03:01	03/03/2021 10:01	150
T1	Almacen1	Planta1	03/03/2021 11:10	03/03/2021 19:01	142

Each row represents a section of the route and its distance, I need to be able to add the distance of the different sections and put it in a total, this in excel I do with formulas, but with DAX I can not find the way.

Thank you for your attention, greetings...

Re: Sum between two dates

v-kelly-msft — Mon, 08 Mar 2021 01:11:22 GMT

Hi Syndicate_Admin ,

Better create a new thread,then we will help to follow it.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

Re: Sum between two dates

Syndicate_Admin — Wed, 30 Jun 2021 17:23:37 GMT

excellent!! contribution!! papaaa!!