cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nrohith Frequent Visitor
Frequent Visitor

Dax Help for two different tables

Hello,

 

I need help with the following. I have the following tables:

 

1. VAS Table with the following values for columns Date and Subject 

2. Sales Table with values for Date and Subject as well.

 

I want to group the VAS and Sales table by date and then subtract the count. For example:

 

VAS:

 

Date                Subject

1/21/2019       aaa

1/21/2019       bbb

1/22/2019       ccc

1/22/2019       ddd

1/22/2019       eee

1/22/2019       fff

 

Sales

 

Date                Subject

1/21/2019       aaa

1/22/2019       bbb

1/22/2019       ccc

 

I have created a date table with unique dates. I want to add a column in it from the previous two tables with the following:

 

Date              Count

1/21/2019      1 (subtracted from VAS - Sales for that date)

1/22/2019      2 (subtracted from VAS - Sales for that date)

 

Any help is appreciated!

 

Thank you! 

 

Neetu 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Dax Help for two different tables

Hi @nrohith

 

Try this for the column, where NewTable is the last table you show:

 

 

Count =
CALCULATE ( COUNT ( VAS[Date] ), FILTER ( VAS, VAS[Date] = NewTable[Date] ) )
    - CALCULATE ( COUNT ( Sales[Date] ), FILTER ( Sales, Sales[Date] = NewTable[Date] ))

 

1 REPLY 1
Highlighted
Super User
Super User

Re: Dax Help for two different tables

Hi @nrohith

 

Try this for the column, where NewTable is the last table you show:

 

 

Count =
CALCULATE ( COUNT ( VAS[Date] ), FILTER ( VAS, VAS[Date] = NewTable[Date] ) )
    - CALCULATE ( COUNT ( Sales[Date] ), FILTER ( Sales, Sales[Date] = NewTable[Date] ))

 

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 68 members 1,056 guests
Please welcome our newest community members: