Forum Discussion
Date Slicer (User Addition + User Removals)
Hi there, I would like to request some help on this..... I have a need to use the Timeline slicer which usually has a Start Date and an End Date Imagine i populate dataset of historical data ...
Bastille92,
To check added rows, you can create the following columns in the combined table.
PreID = CALCULATE(FIRSTNONBLANK(Table1[ID],1),FILTER(Table1,Table1[ID]=EARLIER(Table1[ID]) && Table1[Date]<EARLIER(Table1[Date])))
checkaddrow = IF(ISBLANK(Table1[PreID]) && Table1[Date]>MIN(Table1[Date]),1,0)
Then drag checkaddrow column to visual level filter and set its value to 1.
To check removed rows, the method that I can think of is to create new table listing missing rows between tables using Except() function, there is a similar thread for your reference.
Regards,
Lydia
Hi Lydia,
Thanks for the response
Instead of using calculated column on the existing data set
Do you know any way to create an entirely new table that automatically fills in by referencing the combined file, the ID numbers as the first column by distinct IDs so no duplicate ID
If thats doable, dunno by dax query or by calculated column for the new table...
If thats do-able then using that new table we can have a Add Date and Remove Date column where add date is lookup the ID to find of the minimum date where the ID first occured
Thanks for the response
Instead of using calculated column on the existing data set
Do you know any way to create an entirely new table that automatically fills in by referencing the combined file, the ID numbers as the first column by distinct IDs so no duplicate ID
If thats doable, dunno by dax query or by calculated column for the new table...
If thats do-able then using that new table we can have a Add Date and Remove Date column where add date is lookup the ID to find of the minimum date where the ID first occured