March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
In my table I have 2 dates, start date which is related to the date table and end date which is not related to the date table
I made with no problems the rolling total for start date revenue, but I need to subtract the rolling total of the ends to get the net revenue for the period. I am having problems with the second part given that end date is not related to the date table.
I use the standard DAX date table produced by RADACAD and the relations ship is 'Date Master'[date] to 'mydata'[Calc Start date]
Item | Employee Name | Official Start Date | Calc Start date | End Date | Status | Division | Delivery Center | Total Starts | Calc End Date |
Actuals | Random1 | 16-Jan-23 | 16-Jan-23 | Active | Div 1 | country 1 | 1 | 16-Jan-24 | |
Actuals | Random1 | 3-Apr-23 | 3-Apr-23 | Active | Div 2 | country 2 | 1 | 1-Aug-23 | |
Actuals | Random1 | 4-Aug-22 | 4-Aug-22 | Active | Div 1 | country 3 | 1 | 23-Apr-23 | |
Actuals | Random1 | 7-Nov-22 | 7-Nov-22 | Active | Div 2 | country 1 | 1 | 31-Jul-23 | |
Actuals | Random1 | 7-Feb-22 | 7-Feb-22 | Active | Div 1 | country 2 | 1 | 29-Dec-23 | |
Actuals | Random1 | 27-Dec-22 | 27-Dec-22 | Active | Div 2 | country 3 | 1 | 27-Dec-23 | |
Actuals | Random1 | 16-Jan-23 | 16-Jan-23 | Active | Div 1 | country 1 | 1 | 16-Jan-24 | |
Actuals | Random1 | 16-Jan-23 | 16-Jan-23 | Active | Div 2 | country 2 | 1 | 16-Jan-24 | |
Actuals | Random1 | 4-Apr-23 | 4-Apr-23 | Active | Div 1 | country 3 | 1 | 30-Sep-23 | |
Actuals | Random1 | 7-Sep-21 | 7-Sep-21 | Active | Div 2 | country 1 | 1 | 2-Oct-23 | |
Actuals | Random1 | 27-Dec-22 | 27-Dec-22 | Active | Div 1 | country 2 | 1 | 27-Dec-23 | |
Actuals | Random1 | 27-Dec-22 | 27-Dec-22 | Active | Div 2 | country 3 | 1 | 27-Dec-23 | |
Actuals | Random1 | 14-Nov-22 | 14-Nov-22 | Active | Div 1 | country 1 | 1 | 31-Jul-23 | |
Actuals | Random1 | 16-Jan-23 | 16-Jan-23 | Active | Div 2 | country 2 | 1 | 16-Jan-24 | |
Target | 1-Dec-23 | 31-Dec-23 | Div 1 | country 3 | 4 | 1-Jan-24 | |||
Target | 1-Nov-23 | 31-Dec-23 | Div 2 | country 1 | 4 | 1-Jan-24 | |||
Target | 1-Oct-23 | 31-Dec-23 | Div 1 | country 2 | 4 | 1-Jan-24 | |||
Target | 1-Sep-23 | 31-Dec-23 | Div 2 | country 3 | 4 | 1-Jan-24 | |||
Target | 1-Aug-23 | 31-Dec-23 | Div 1 | country 1 | 3 | 1-Jan-24 | |||
Target | 1-Jul-23 | 31-Dec-23 | Div 2 | country 2 | 2 | 1-Jan-24 | |||
Target | 1-Jun-23 | 31-Dec-23 | Div 1 | country 3 | 2 | 1-Jan-24 | |||
Target | 1-May-23 | 31-Dec-23 | Div 2 | country 1 | 1 | 1-Jan-24 | |||
Target | 1-Apr-23 | 31-Dec-23 | Div 1 | country 2 | 1 | 1-Jan-24 | |||
Target | 1-Dec-23 | 31-Dec-23 | Div 2 | country 3 | 4 | 1-Jan-24 | |||
Target | 1-Nov-23 | 31-Dec-23 | Div 1 | country 1 | 4 | 1-Jan-24 | |||
Target | 1-Oct-23 | 31-Dec-23 | Div 2 | country 2 | 4 | 1-Jan-24 | |||
Target | 1-Sep-23 | 31-Dec-23 | Div 1 | country 3 | 4 | 1-Jan-24 | |||
Target | 1-Aug-23 | 31-Dec-23 | Div 2 | country 1 | 3 | 1-Jan-24 | |||
Target | 1-Jul-23 | 31-Dec-23 | Div 1 | country 2 | 2 | 1-Jan-24 | |||
Target | 1-Jun-23 | 31-Dec-23 | Div 2 | country 3 | 2 | 1-Jan-24 | |||
Target | 1-May-23 | 31-Dec-23 | Div 1 | country 1 | 1 | 1-Jan-24 |
can you please provide sample data to better understand
do you have calendar table? and what is master date? and cant you copy the table instead of picture to insert it directly to powerbi ?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
25 | |
17 | |
16 | |
12 | |
11 |
User | Count |
---|---|
39 | |
29 | |
27 | |
20 | |
18 |