Calculation Reuired Date Filtering

[Anonymous]

Hi Experts ,

I am new to power bi and need help on the same on the calculation of relative filters between 2 or more date fields and show Sales Amount

Sum of Sales when 

1.Effective date within the date range selected(inclusive) and the Entry date is less than financial closing date for End of range selected

2. Effective date prior to the selection start date and entry date between financial opening date for Start of range selected and financial closing date for end of range selected(inclusive).

All dates are available in a single view .Hope someone helps me on the same .

Regards ,

Sunny 

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

It is very difficult to analyze without looking at the data and just by imagining. Based on your description, you could create measures to calculate data within the date range. You can refer to the DAX below:

Measure = 
CALCULATE ( 
	SUM ( table[SalesAmount] ),
	FILTER ( table, 
		table[Effective date] <= MAX ( table[Date] ) && 
		table[Effective date] >= MIN (table[Date]) &&
		table[Entry date]<= table[financial closing date]
	) 
)

if this is not the result you want, please provide some sample data or paste pictures, so that we can help you solve the problem.

Best Regards,

Liang 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.