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...
Need Help
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?