Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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)))
O
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)))
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)))
O
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)))
excellent!! contribution!! papaaa!!
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...
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!
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)) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |