Forum Discussion

Pawel_1990's avatar
Pawel_1990
Helper I
1 year ago
Solved

Slowly Changing Dimension and Direct Query

Hello, I am using direct query in my report. I have currently 4 tables: - Standard Dim_Date - Fact_Table with shape: Account_ID Transaction_ID Transaction_Date Transaction_Value 1 ...
Need Help
  • Pawel_1990's avatar
    Pawel_1990
    1 year ago

    Hello,

    Thank you for help rohit1991 - your solution also only work in Import mode. But I found workaround.

    In Power Query I wrote manual SQL code. I created foreign key using Account_ID and first date of month in tables:
    - Historical_Account _Dim
    - Fact_Table (used Transaction Date to get first day of month)

    With new key I was ablo to retrieve data. Anonymous Case can be closed

Pawel_1990's avatar
Pawel_1990
Helper I
1 year ago

Hello,

Thank you for help rohit1991 - your solution also only work in Import mode. But I found workaround.

In Power Query I wrote manual SQL code. I created foreign key using Account_ID and first date of month in tables:
- Historical_Account _Dim
- Fact_Table (used Transaction Date to get first day of month)

With new key I was ablo to retrieve data. Anonymous Case can be closed