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
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.
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