Forum Discussion

sven7's avatar
sven7
Frequent Visitor
8 years ago
Solved

In and out-flow from money. Create difference and aggregate value by month.

Dear Power Bi Users,   I am struggling with a little issue right now. I did some research in this forum but did not find the right solution. Maybe I am just on the wrong path, this is why I hope th...
  • MFelix's avatar
    MFelix
    8 years ago

    Hi sven7,

     

    You are using a column you should use a measure, columns are always calculated at row level, measures are calculated at context level so taking into account the different levels of information.

     

    Change your column to a measure and it will work,

     

    Regards,

    MFelix

sven7's avatar
sven7
Frequent Visitor
8 years ago

MFelix Thank you for your patience. I do not know where I make my mistake, I have used just some simple data to reproduce your table, but still the same issue. Please see here. 

 

Hope we can find my mistake. BR Sven

 

MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

Hi sven7,

 

You are using a column you should use a measure, columns are always calculated at row level, measures are calculated at context level so taking into account the different levels of information.

 

Change your column to a measure and it will work,

 

Regards,

MFelix

  • sven7's avatar
    sven7
    Frequent Visitor
    8 years ago

    MFelix What a stupid mistake... All working now, thank you very much. 

     

    It really helps to visualize our data. Thanks