Forum Discussion

patator35's avatar
patator35
Frequent Visitor
8 years ago

Table Nested Joint - where clause

Hello

 

I'm builing up a summary table of sales targets and past year sales.

I would like to add a column to my table containing sales of a pre-set year (ie 2015).

 

In the following  formula, I would like to add a "where" clause :

= Table.NestedJoin(#"Valeur remplacée",{"ID_Target"},Targets_Data_Year,{"ID_Target"},"Targets_Data_Year",JoinKind.LeftOuter,)

 

..where Targets_Data_Year.Year="2015"

 

How can I do that ?

thanks for your help

Need Help

7 Replies

  • patator35's avatar
    patator35
    Frequent Visitor
    8 years ago

    Hello again

     

    I'm really stuck and would appreicate any kind of support helping me to advance.

    Maybe my question was not clear, please let me know if this is the case...

     

    thanks

      • patator35's avatar
        patator35
        Frequent Visitor
        8 years ago

        Ricardo

         

        thanks for your support.  

        2 reasons :

        - i use the year table for other queries and don t want to prefilter it

        - I will use this "year sales" table to add 3 columns in the "target" table (containing the nested join fonction) : 2015 sales | 2016 sales | 2017 sales