Forum Discussion

yfquirogah's avatar
yfquirogah
Helper I
6 years ago
Solved

Filter in data base

I have this issue:   I have 2 tables, the first one shows Positions that have been removed, the date this happened and a column that indicates a code that belongs to an specific area; the second ta...
Need Help
Show and Tell
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    Hi yfquirogah ,

     

    Based on your description, you want to display "function" of Table 2 according to "month", "year" and "CE. Coste" in Table 1.

    You can try to concatenate "month" "year" "CE. Coste" and create a relationship for the two tables.

    Column = CONCATENATE('Table'[Year],CONCATENATE('Table'[Month],'Table'[Ce.coste]))

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

V-lianl-msft's avatar
V-lianl-msft
Community Support
6 years ago

Hi yfquirogah ,

 

Based on your description, you want to display "function" of Table 2 according to "month", "year" and "CE. Coste" in Table 1.

You can try to concatenate "month" "year" "CE. Coste" and create a relationship for the two tables.

Column = CONCATENATE('Table'[Year],CONCATENATE('Table'[Month],'Table'[Ce.coste]))

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.