show last quarter and selected quarter data

[ndris]

Hello EveryOne , 

Please i need our help about my issue . 

This is my datamodel 

 I want when i  selectected Only (30/06/22) in my reportingdate slicer, get data of 

This selected  reportingdate and previousreportingdate in a matrix . something like below 

my call measure is : 

calls =

CALCULATE(

SUM( CashFlows[Paid])

, FILTER( CashFlows,

CashFlows[IsInvestorCurrency]=TRUE()

&& CashFlows[OperationDate] <= SELECTEDVALUE(ReportingDate[ReportingDate])

)

)

Please I need your help 

kind

[v-xiaotang]

Hi @ndris 

Thanks for reaching out to us.

please share a sample file or some sample data and give your expected output according to it.

and when you select 30/05/22 in slicer, then what the output should be?

Best Regards,

Community Support Team _Tang

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

[ndris]

Hi @v-xiaotang , 

Sorry for an error occured in my previous message , It's 30/06/22 not 30/05/22 . 

So when i select 30/06/22 in a simple selected value (not multiselected )  i want to get calls and distribution of  30/06/22 and 31/03/22 in a matrix  like below 

Cashflow Table

calls

Distribution 

operationdate (it's not end of quarter)

Reporting date

Reportingdate(it's end of quarter )

reportingdateQ-1