DAX Help

[jake32008]

Hi,

I have 4 tables, the 1st with transactional data by product and customer in the future (forecasts), the 2nd with transactional data by product and customer in the past, the 3rd with product data, and the 4th with customer data.

I am creating a pivot table with product and customer table data on rows and transactional data in the values.

What I am trying to avoid is rows for product and customer combinations that do not have future transactional data even if there is historical data that would otherwise create the row.

I've tried to create a measure that would return a binary of 1 or 0 that I could filter on but have not yet been able to create a binary that I can effectively filter on.

Thanks for your help!

 

[Matt Allington]

I’m not clear exactly what you need. Are you saying that if there is a product/customer combination in “future”, then, and only then, you want to see the sales history? If this is always the case and you never want to see the rest of the history, my intuition is to simply not load the history you don’t need. You could do this in PQ. Join the history table to the future table on 2 columns, prod and cust, and do an inner join. This will keep history data only if the combination exists in the future table.
for simplicity, I would then append the filtered history table to the future table. Make sure you add a new column to identify history or future rows.