Forum Discussion

Bastille92's avatar
Bastille92
Frequent Visitor
8 years ago

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 ...
Need Help
Bastille92's avatar
Bastille92
Frequent Visitor
8 years ago

Add Date = Calculate(MIN('Snap Historical'[Snap Date]),FILTER(ALL('Snap Historical'[C-Number]),'Snap Historical'[C-Number]='Table'[C-Number]),FILTER(ALL('Snap Historical'[Snap Date]),'Snap Historical'[Snap Date]>='Table'[Removed Date]))

 

Is this right??

 

Can i be using >= or it needs to be in a specific format like on Excel where its >=&'Table'[Removed Date]

Bastille92's avatar
Bastille92
Frequent Visitor
8 years ago

Bump,

 

still awiting on a resoponse to see if the formula for hte previous post for the >= works or it has to be >=&

 

Regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Bastille92，

    What are the tables(Snap Historical, Table) do you refer to in your DAX? And what is the expected result based on the new Table 1 and Table 2?

    Regards,
    Lydia