Forum Discussion

pbi1908's avatar
pbi1908
Icon for Helper III rankHelper III
3 years ago
Solved

Sales and Purchase in the same table

Hi everyone,    I have a table which contains Sales and Purchase and all the information gathered together.  The sales are conntecte with Purchase since is a trading table so i have a Sale (ID 11)...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

    Have you created the measure filter as I recommended?

pbi1908's avatar
pbi1908
Icon for Helper III rankHelper III
3 years ago

lbendlin 

Yes now is working thanks 🙂

 

Just a last quesiton, do you think that to use as a bridge table the unified one instead of the Calendar is a good idea?

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

I would not recommend that. Usually bridge tables are an indicator for deeper problems.

 

Learn to use TREATAS() instead.

  • pbi1908's avatar
    pbi1908
    Icon for Helper III rankHelper III
    3 years ago

    lbendlin In that case i need a Column with TREATAS() function in Purchase table, wich will filter the table when i click to the related sale. Something like this i guess.