Forum Discussion
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 ...
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
Hi Pawel_1990
I wanted to check if you had the opportunity to review the information provided by rohit1991 . Please feel free to contact us if you have any further questions. If his response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.