Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Calculating sum filtering by comparing dates from two different tables

Hi all,   Thanks for your help upfront. Always a pleasure to see how fast everyone is reacting. So quickly:   I need to compare the orders from table 1 to the deliveries of table 2. Table 1: St...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , You need to have three dimension tables. 

1. Date (Both tables it will join two dates, one active /one inactive. Use userelationship)

 

2. SKU

 

3. Store

 

For the first one refers:

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

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

 

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

 

For 2-3 refer

https://www.youtube.com/watch?v=Bkf35Roman8

 

Also read: https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Amit,

 

Thanks for all the links. been through each one fo them but still don't really see how I can do a time comparison between tables in a calculate(sum) context.

Let me try to rephrase:

- I need to sum all sales (from sales table)

- if the date (from sales table) is greater than movement date (from order table)

 

Thanks