Forum Discussion
Diff with previous date
Thanks for your help.
I have solved it after reading this (https://community.powerbi.com/t5/Desktop/Find-value-for-first-and-last-date-by-person/m-p/62016).
Regards
Tobias
- Column "table" is. I have added column "What report" when tried to solve this.
- The reason for the column "What report" is to have a fixed value.
(Column "What report" is defind in a related table "Report_tbl", with column "Date","What report")
- The table names are not fixed, it is the top 10 tables in customer database.
Ok so this is helping me consider the right direction. My next question then, so for the "current" or "previous report flags, how many distinct table names would be under a distinct date? If it's always two you could use FIRST/LAST NONBLANK functions to call those rows when calculating current or previous report counts. If it's more than two then we'd need to figure out how to find each distinct table name and compare the count values with the current and previous dates.
The table can only exist one time for "Current" and one time for "Previous".
Thanks for your help.
I have solved it after reading this (https://community.powerbi.com/t5/Desktop/Find-value-for-first-and-last-date-by-person/m-p/62016).
Regards
Tobias