Open Side Menu
Skip to contentBrand Logo
Forums
Inspiration
Ideas
Communities
Blogs
Learning
Support
RegisterSign In
  1. Microsoft Fabric Community
  2. Power BI forums
  3. Desktop

Forum Discussion

LAndris's avatar
LAndris
Helper I
6 years ago
Solved

Filtering Slow Changing Dimension and Facts table with Date Range Slicer

Hello,   I am attempting to use a date range slicer to filter the following two tables    Table 1: Slow Changing Claim Table with Foreign Keys.                               ...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    LAndris ,

    refer

    https://powerpivotpro.com/2019/06/how-can-i-get-a-lookup-table-from-a-slowly-changing-dimension-scd/

    https://www.zartis.com/scd-implementation-with-temporal-tables-in-power-bi/

    https://community.powerbi.com/t5/Desktop/Use-a-Slowly-Changing-Dimension-SCD-to-allow-a-user-to-select-2/m-p/1263389/highlight/false#M555395

amitchandak's avatar
amitchandak
Super User
6 years ago

LAndris ,

refer

https://powerpivotpro.com/2019/06/how-can-i-get-a-lookup-table-from-a-slowly-changing-dimension-scd/

https://www.zartis.com/scd-implementation-with-temporal-tables-in-power-bi/

https://community.powerbi.com/t5/Desktop/Use-a-Slowly-Changing-Dimension-SCD-to-allow-a-user-to-select-2/m-p/1263389/highlight/false#M555395

Related content
  • degenerate dimensions

    9 months ago
    Jeanxyz
  • RLS Filtering additional dimensions

    8 months ago
    Chewdata
  • Dynamic change Ranking based on Dimension change

    8 months ago
    Raju_KCS
  • Remove filters from a dimension

    9 months ago
    EstherBR
  • RLS on multiple dimensions

    6 months ago
    kvnbn
  • © 2026 Microsoft
  • Manage cookies
  • Privacy & cookies
  • Terms of use
  • Trademarks
Your Privacy Choices Consumer Health Privacy