Forum Discussion

Halah_MS's avatar
Halah_MS
Frequent Visitor
3 years ago

Create Quarter Column to my table without Date

I have a table that is for Sales Target for each branch, the total of each branch is distributed into 4 quarters. Each quarter has a different percentage that adds up to 100%. so this is how my table looks like

 

BranchIDSales TargetQuarter
110,000$Q1
120,000$Q2
115,000$Q3
110,000$Q4
220,000$Q1

 

and so on.

 

I have BranchTable that identifies the BranchID and Sales table and Date Table that are connected in relationships. 

When I connect Target Table to BranchTable the data is shown perfectly, however when I connect quarter to my Date table it shows data as blank. No errors just blank. 

 

 

How do I connect my Target Table so I can connect it to Date table that is also connected to Sales Table?

 

 

Need Help

2 Replies

  • djurecic's avatar
    djurecic
    Icon for Super User rankSuper User
    3 years ago

    Hi Halah_MS ,

     Are you relating BranchGPTarget[Quarter] to Date[Date] or Date[Quarter]? Try Date[Quarter] if you are not already doing that.

     

    • Halah_MS's avatar
      Halah_MS
      Frequent Visitor
      3 years ago

      I tried to relate it to Date[Quarter] but it gives me many to many relationship warning, and when I relate it to Date[Date] the results are blank.

       

      I added year column thinking it might make more sense but it still gives many to many relationship.

       

      How to fix this?