0

1

How do I create a relationship between these 4 fact tables and 2 dim tables? How do I slice them based on quarter of the year? How to insert Q1 2023 into the fact tables?

When I change from Q1 to Q2 on the slicer, the count of MemberID doesn't change accordingly. Why is that? Thank you so much in advance.

Davide Bacci
  • 16,647
  • 3
  • 10
  • 36
Nhubao Rai
  • 13
  • 2
  • I can't see your tiny picture but obvioulsy the slicer won't do anything until you have relationships set up – Nick.Mc Feb 05 '23 at 11:44

1 Answers1

1

You need to reshape your data in Power Query. Append your 4 tables so you have a single fact table. You can also remove MemberName from your fact table as it is already in your dimension table so just retain MemberID in your fact.

Davide Bacci
  • 16,647
  • 3
  • 10
  • 36