Forum Discussion

Wresen's avatar
Wresen
Post Patron
7 years ago
Solved

IF statment for second table not found

Hi all I have problem a with IF statement for the second table (its a bit complicated but i will try and explain it) I have 2 tables linked together FIXED MONTH and MONTH 2 is linked together...
Need Help
  • PhilC's avatar
    PhilC
    7 years ago

    Hi,

     

    Firstly, this might be better placed in the Power BI forum, rather than Power Query as it is a model question, not a query editing question.

     

    A picture of the data model (ie how the tables are linked) would be good, along with your measures.  If you can provide the file, or a mockup if the data is confidential, even better.

     

    Try linking FIX MONTH in Table 1 and MONTH 2 in Table 2 to the SLICER MONTH field, so they are linked via that table, not directly.

     

    Cheers

     

PhilC's avatar
PhilC
Resolver I
7 years ago

Hi,

 

Firstly, this might be better placed in the Power BI forum, rather than Power Query as it is a model question, not a query editing question.

 

A picture of the data model (ie how the tables are linked) would be good, along with your measures.  If you can provide the file, or a mockup if the data is confidential, even better.

 

Try linking FIX MONTH in Table 1 and MONTH 2 in Table 2 to the SLICER MONTH field, so they are linked via that table, not directly.

 

Cheers

 

  • Wresen's avatar
    Wresen
    Post Patron
    7 years ago

    Thanks so much for the help, and i am sorry that i put this in the wrong forum

     

    Linking the Slicer Month fields did the trick , it seems to work now as it should :)