Create report based on payment date

[robson-andrade]

Dear all, good afternoon!

Could you please help me.

I have this view set up of a report, where these columns are already handled within Power Query, that is, I haven't needed to use DAX until now.

My question.

1st Point: In the filter above, the calendar is linked to the date of issue of the document

2nd Point: In this report I have the last payment column "E2_Baixa"

3rd Point: My calendar has it linked to the date of issue of the document and also the date of discharge (Payment)

Goal:

When filtering the year above, the system ignores the issue date and shows it in the report based on the payment date.

Can you help me.

Att.

Robson

[sevenhills]

First and foremost I dont know spanish or the language of your posted images  .

I am assuming you are doing the role playing date dimension and want each visual to behave of the corresponding date of your choice. 

Say, you have one transaction table and has connected to date table to two columns. You want one table visual as to use one date column. other visual as to use other date column. Filter/slicer is the same for all. This is common scenario.

You need to create measures and code them using USERELATIONSHIP. 

Please check:   

https://dax.guide/userelationship/

https://www.sqlbi.com/articles/using-userelationship-in-dax/

Sample MDX, which uses delivery date (inactive relationship).

Delivery Amount =
CALCULATE (
    [Sales Amount],
    USERELATIONSHIP ( Sales[Delivery Date], 'Date'[Date] )
)

 Hope it helps!