Forum Discussion
Solved
Relationships cardinality
Hello i am trying to link the two tables below by account id, but keep getting them message regarding cardinality and i am unable to find a link that works to allow me to build a combination chart sh...
Thanks for this, I'm sure that this works but I am still unable to undersatnd how to do it thats just my weakness with power bi, i will give up on trying to do this but will accept that this is probably the solution.
Below is what i am trying to replicate with some sample data below.
ALL SITE | ||||
| SITE_ID | ACCOUNT_ID | Customer Name | Date | SQM |
| LOC | 2000099 | ABCDEF | 01/04/2024 | 24419 |
| LOC | 2000099 | ABCDEF | 15/04/2024 | 5814 |
| BEL | 700373 | HIJJJJ | 25/04/2024 | 25256 |
| BEL | 700373 | KNNNN | 30/04/2024 | 31524 |
| BUR | 1010566 | XXXXXX | 10/04/2024 | 27054 |
| BUR | 1010566 | XXXXXX | 18/04/2024 | 3251 |
| FEA | 101021 | ZZZZZZ | 06/04/2024 | 15362 |
| S&OP | ||||
| ACCOUNT_ID | Month Name | SQM | SITE_ID | |
| 2128 | April | 825000 | LIV | |
| 200976 | April | 35000 | FEA | |
| 2775 | April | 26486 | LIV | |
| 600146 | April | 4783 | BUR | |
| 2002403 | April | 25200 | LOC | |
| 600079 | April | 35000 | BUR | |
| 600139 | April | 400000 | BUR | |
| CALENDER | ||||
| Date | Year | Month | Month Name | |
| ######## | 2024 | 4 | April | |
| ######## | 2024 | 4 | April | |
| ######## | 2024 | 4 | April | |
| ######## | 2024 | 4 | April |
Add the date column:
Create the calendar and wire it in:
Calendar = ADDCOLUMNS(CALENDAR("2024-04-01",TODAY()),"Year",FORMAT([Date],"yyyy"),"Month",FORMAT([Date],"mmm"),"MNo",FORMAT([Date],"mm"))
Then you can base your visuals x axis on the calendar.
Thanks for this, I'm sure that this works but I am still unable to undersatnd how to do it thats just my weakness with power bi, i will give up on trying to do this but will accept that this is probably the solution.