Forum Discussion
charts values changed by 2 different dates
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 , 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
2 Replies
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
Thanks 🙂
i've created a metric to control the data flow.
