Forum Discussion
Filter values based on second calendar table
Hi experts!
I have a sales table linked to a calendar table.
This values are displayed in a matrix in this format:
2023-Jan
2023-Feb
2023-Mar
...
...
...
...
...
...
......
are you sure that Cycle is a disconnected table?
tamerj1 : Now I tested you approach in a new PBI File and I get this failure:
cannot display the data because power bi can't determine the relationship between two or more fields
Yes, I just have a relation between Date and Sales table. Cycle Table has no relationship to the other tables
First place the measure in the visual then the columns