Forum Discussion

michaelsh's avatar
michaelsh
Icon for Kudo Kingpin rankKudo Kingpin
5 years ago

Dynamically compare snapshots: before vs. after

I have a table of snapshots. For each employee I have an attribute (department, manager, salary bin, position, etc.) and for each attribute - I have it's value. I want my users to pick 3 things fro...
Need Help
michaelsh's avatar
michaelsh
Icon for Kudo Kingpin rankKudo Kingpin
5 years ago

Thank you, Anonymous !

I appreciate your help.

If no one shows up with the dynamic measure idea, I'll mark yours as a solution.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi michaelsh ,


Sorry to disturb you...

Please mark my reply as solution. Thank you very much.

 

Best Regards,
Stephen Tao

  • michaelsh's avatar
    michaelsh
    Icon for Kudo Kingpin rankKudo Kingpin
    5 years ago

    I actually have an alternative - dynamic solution, but I haven't tested it yet.
    M1 = VAR vSelectedDateBefore = SELECTEDVALUE ( SnapshotDateBefore[SnapshotDate], MIN ( SnapshotDateBefore[SnapshotDate] ) ) VAR vSelectedDateAfter = SELECTEDVALUE ( SnapshotDateAfter[SnapshotDate], MAX ( SnapshotDateAfter[SnapshotDate] ) ) RETURN COUNTROWS ( FILTER ( ADDCOLUMNS ( VALUES ( Data[Employee] ), "cBeforeFl", CALCULATE ( NOT ( ISEMPTY ( Data ) ), Data[SnapshotDate] = vSelectedDateBefore, Data[AttributeValue] IN VALUES ( DepartmentBefore[AttributeValue] ) ), "cAfterFl", CALCULATE ( NOT ( ISEMPTY ( Data ) ), Data[SnapshotDate] = vSelectedDateAfter, Data[AttributeValue] IN VALUES ( DepartmentAfter[AttributeValue] ) ) ), [cBeforeFl] && [cAfterFl] ) )