charts values changed by 2 different dates

[jppuam]

Hello,

i have a table with products and 2 dates.

i want to show the data (like the blue chart), with the date field from calendar table, and selected on the filter above the date field that i want (received or ship date) and automatically chage the chart. How can i make this ?

below (in purple and red are the charts with received and ship date)

My calendar table is linked with received date.

thanks,

JR

[jppuam]

Thanks 🙂

i've created a metric to control the data flow.

[amitchandak · Accepted solution]

@jppuam , Create a common date/calendar Table, Join with both dates one date will be inactive, You can activate it in measure using use relationship

Example- which ever date is inactive that needs it

calculate(Sum(Table[Qunatity]), USERELATIONSHIP(Calender[Date];'Table1'[Ship Date]) )

or

calculate(Sum(Table[Qunatity]), USERELATIONSHIP(Calender[Date];'Table1'[Received Date]) )

refer

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...