Select all invoices between posting date and selected period

[Khalidc]

Hi

I have a sales invoice table presenting all historic invoices "CustomerInvoice". The invoice table has a column "posting period" and a column "closing period". The posting period is the period the invoice was posted, and closing is the period where the cash was received and invoice closed. I would like to populate an invoice subledger based on the selected period in a slicer which is coming from the period date table "visma_ financialPeriod".

I have created the following measure but it only returns the invoices having posting periods = selected financialperiod and not the invoices which where posted before the selected financial period:

It must be easy to solve, but I just cannot see it at this moment. 

[Daryl-Lynch-Bzy · Accepted solution]

Hi @Khalidc - I am not sure about the VAR for post and close period.  Would something like the following work.

Account Receivable Subledger = 
VAR _period = SELECTEDVALUE ( Visma_financialperiod[Period] , MAX ( Visma_financialperiod[Period] ) )
RETURN
CALCULATE ( SUM ( Visma_customerInvoice[Amount] ) , 
       Visma_customerInvoice[postperiod adj] <= _period , 
       Visma_customerInvoice[closedfinancialperiod] > _period  || 
       ISBLANK( Visma_customerInvoice[closedfinancialperiod] 
)

[Khalidc]

Thanks! 

First it returned the exact same result but after adding the ALL() to it, it worked, see in red!

CALCULATE(sum(Visma_customerInvoice[amount]),

all(Visma_financialPeriod),

Visma_customerInvoice[postperiod adj] <= _period ,

Visma_customerInvoice[closedFinancialPeriod] > _period ||

isblank (Visma_customerInvoice[closedFinancialPeriod]))