SCD 2 type data calculation in Tabular Model/Power Pivot RRS feed

  • Question

  • Hi All,

    Currently we have data is the attached format which SCd type 2..keeping all the historical information.I need to pull the same record in tabular model and find how many id were present in particular month with particular status. As Effective start date and end date will contain only range not the complete date details.Could anyone please let me know how to join with date table and DAX calculation for this? Please let me know if you need further information regarding the same.

    Thanks Chandan

    Wednesday, September 9, 2015 3:22 PM


All replies