Forum Discussion

Russ99's avatar
Russ99
Icon for Helper I rankHelper I
4 years ago
Solved

converting column to measure

Hi Community,   I think this is a noobish question but one i am struggling with never the less.    I have a column called name and a column called payment days, I want to be able to use payment d...
Need Help
  • DataVitalizer's avatar
    DataVitalizer
    4 years ago

    Hi Russ99 

    Can you make sure that both tables are related to each other from the model view?

     

    Did it work ? 👌Mark it as a solution to help spreading knowledge 👉A kudos would be appreciated

Russ99's avatar
Russ99
Icon for Helper I rankHelper I
4 years ago

yep they are related with a one to many relationship as intended. thanks for  your help

DataVitalizer's avatar
DataVitalizer
Icon for Super User rankSuper User
4 years ago

You have two related tables (A & B), in your report you added a visual in which you added Supplier name from Table A, and in the same visual you added a measure which calculates Sum [payment days]
If you have followed these steps the calculation is supposed to be correct.

In case you file does not contain sentivie data could you share a sample here?

 

Did it work ? 👌 Mark it as a solution to help spreading knowledge 👉 A kudos would be appreciated