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:
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:
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!
Go to Solution.
Try this for the column, where NewTable is the last table you show:
CALCULATE ( COUNT ( VAS[Date] ), FILTER ( VAS, VAS[Date] = NewTable[Date] ) )
- CALCULATE ( COUNT ( Sales[Date] ), FILTER ( Sales, Sales[Date] = NewTable[Date] ))
Power BI Super User, Greg Deckler, explains
Engage and empower students with Power BI!
Continue your learning in our online communities.