Forum Discussion

joshua1990's avatar
joshua1990
Icon for Post Prodigy rankPost Prodigy
3 years ago

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 ... ... ... ... ... ... ......
Need Help
joshua1990's avatar
joshua1990
Icon for Post Prodigy rankPost Prodigy
3 years ago

Let's take C as an example. Here the date is 01.03.2023.

So in the matrix I would get an value for 2023-Jan and 2023-Feb since both months are before the selected C cycle.

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

joshua1990 

are you sure that Cycle is a disconnected table?

  • joshua1990's avatar
    joshua1990
    Icon for Post Prodigy rankPost Prodigy
    3 years ago

    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

     

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    joshua1990 

    First place the measure in the visual then the columns