AnonymousNot applicable6 years agoSolvedDate filter Hello, I'm having the following problem. I have a couple of sales tables relating to a date table as well as a persons table. Now, i'm adding a table to define the teams for each person. The...Show Moreamitchandak6 years agoThis is an SCD case. Please refer.https://powerpivotpro.com/2019/06/how-can-i-get-a-lookup-table-from-a-slowly-changing-dimension-scd/https://zartis.com/scd-implementation-with-temporal-tables-in-power-bi/https://community.powerbi.com/t5/Desktop/Select-correct-slowly-changing-dimension-record-based-on/td-p/324256https://community.powerbi.com/t5/Desktop/How-to-find-number-of-customers-in-a-SCD2-type-table/td-p/97192
amitchandak6 years agoThis is an SCD case. Please refer.https://powerpivotpro.com/2019/06/how-can-i-get-a-lookup-table-from-a-slowly-changing-dimension-scd/https://zartis.com/scd-implementation-with-temporal-tables-in-power-bi/https://community.powerbi.com/t5/Desktop/Select-correct-slowly-changing-dimension-record-based-on/td-p/324256https://community.powerbi.com/t5/Desktop/How-to-find-number-of-customers-in-a-SCD2-type-table/td-p/97192
amitchandak6 years agoThis is an SCD case. Please refer.https://powerpivotpro.com/2019/06/how-can-i-get-a-lookup-table-from-a-slowly-changing-dimension-scd/https://zartis.com/scd-implementation-with-temporal-tables-in-power-bi/https://community.powerbi.com/t5/Desktop/Select-correct-slowly-changing-dimension-record-based-on/td-p/324256https://community.powerbi.com/t5/Desktop/How-to-find-number-of-customers-in-a-SCD2-type-table/td-p/97192
amitchandakSuper User6 years agoThis is an SCD case. Please refer.https://powerpivotpro.com/2019/06/how-can-i-get-a-lookup-table-from-a-slowly-changing-dimension-scd/https://zartis.com/scd-implementation-with-temporal-tables-in-power-bi/https://community.powerbi.com/t5/Desktop/Select-correct-slowly-changing-dimension-record-based-on/td-p/324256https://community.powerbi.com/t5/Desktop/How-to-find-number-of-customers-in-a-SCD2-type-table/td-p/97192
Related contentDate filters for VisualizationFiltered DateRemoving date filterBetween date filter with fixed start date and latest end dateCreating a Date Filter in Power BI
