Forum Discussion
Getting a movement based on key and 2 dates
Hi guru's,
I am struggling on how to achieve my requirement in powerBI (in excel I would jsut create some sumifs etc).
I have (for example) a single table imported.
The columns are (cutdown):
Key, Date, Count.
I have about 10,000 rows across 4 dates (at the moment).
I can easily create a baseline count (e.g.
Baseline =
CALCULATE(SUM('Table1'[count]), 'Table1'[Date] IN { DATE(2022, 8, 25) })
What I now need is to see which keys are new on a later date (say date = 31 Dec 2022) and return the count sum for these rows.
I can do the same as above to get the actual total count, but cannot figure out how to do a dax to say if "Baseline" key is Null (or zero?) then return the sum count of all the rows that are not on the "baseline" row
Any help would be greatfully received.
Thanks
Jon
No Replies