Filter/Summarize Date with Start and End Date via 2 Tables

[akih1to]

Hello Everyone,

I'm relatively new to Power BI, I'm wondering if I can make a measure of summarized date per specific critieria.

To give a thought, I have 2 tables containing the start and end date of a criteria and the other just the date table (starting Jan 1, 2022 - current date).

What I want to happen is that my line graph would only contain the monthly sales of that specific criteria from its start to end date.

Thanks!

[akih1to]

Hello Ashur,

Sorry about that

Outcome is below and the table, the other table is just a normal date table starting from 1/1/2023.

I would want that the line graph would show the start and end date only of that specific criteria (I filtered the outcome below just to show what it is), currently my date is always starting at Jan 2023 because it is what my x-axis currently has.

Thanks!

 

Start Date	End Date	Criteria
01/16/2024	01/16/2025	A
05/01/2023	05/01/2024	B
07/01/2023	07/01/2024	C
09/01/2023	09/01/2024	D
09/01/2023	09/01/2024	E
09/01/2023	09/01/2024	F
08/16/2023	08/16/2024	G
08/16/2023	08/16/2024	H
01/01/2024	01/01/2025	I
01/01/2024	01/01/2025	J
01/01/2024	01/01/2025	K
01/01/2024	01/01/2025	L
01/01/2024	01/01/2025	M
09/01/2023	09/01/2024	N
01/01/2024	01/01/2025	O
01/01/2024	01/01/2025	P
01/01/2024	01/01/2025	Q
05/01/2023	05/01/2024	R
01/01/2024	01/01/2025	S
09/01/2023	09/01/2024	T
01/01/2024	01/01/2025	U
01/01/2024	01/01/2025	V
01/01/2024	01/01/2025	W
01/01/2024	01/01/2025	X
01/01/2024	01/01/2025	Y
01/01/2024	01/01/2025	Z
01/01/2024	01/01/2025	A1
01/01/2024	01/01/2025	B1
01/01/2024	01/01/2025	C1
01/01/2024	01/01/2025	D1
01/01/2024	01/01/2025	E1
01/01/2024	01/01/2025	F1
01/01/2024	01/01/2025	G1
01/01/2024	01/01/2025	H1
01/01/2024	01/01/2025	I1
01/01/2024	01/01/2025	J1
01/01/2024	01/01/2025	K1
01/01/2024	01/01/2025	L1
01/01/2024	01/01/2025	M1
01/01/2024	01/01/2025	N1
10/01/2023	10/01/2024	O1
02/01/2024	02/01/2025	P1
10/01/2023	10/01/2024	Q1
06/01/2023	06/01/2024	R1
06/01/2023	06/01/2024	S1
03/01/2024	03/01/2025	T1
02/01/2024	02/01/2025	U1
08/16/2023	08/16/2024	V1
08/01/2023	08/01/2024	W1
08/01/2023	08/01/2024	X1
06/01/2023	06/01/2024	Y1
03/01/2024	03/01/2025	Z1
03/01/2024	03/01/2025	A2
04/01/2023	04/01/2024	B2
05/16/2023	05/16/2024	C2
08/01/2023	08/01/2024	D2
10/01/2023	10/01/2024	E2

[Ashish_Mathur · Accepted solution]

I have solved a similar problem in the attached file.  Please review the measures used there and apply them to your data/file.

[Ashish_Mathur]

Hi,

Share data in a format that can be pasted in an MS Excel file.  Show the expected result very clearly.