Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Need help on calculation

Hi there, i need some help with a calculation . i have two tables below.   Table1 with 'user' column.  i have total 8 users. this number may change every day.                                        ...
Need Help
  • TeigeGao's avatar
    TeigeGao
    7 years ago

    Hi Anonymous ,

    Actually, we can use SUM() or MAX() or other Aggregate function in this scenario, in "message[date] =" the = operator can only accept a scalar rather than a column "'Table'[date]", as a result, we need to use a Aggregate function to change the column to a value.

    But don't be worried about this, actually, in this scenario, only one value in the column "'Table'[date]" becuase it has been filtered by the table visual, as a result, SUM(), MIN(), MAX() can get the same result.

    Best Regards,

    Teige

Anonymous's avatar
Anonymous
Not applicable
7 years ago

thanks for reply.....TeigeGao in the Measure expression, . why did u use 'MIN('Table'[date]'...  im not able to undertsand 

TeigeGao's avatar
TeigeGao
Solution Sage
7 years ago

Hi Anonymous ,

Actually, we can use SUM() or MAX() or other Aggregate function in this scenario, in "message[date] =" the = operator can only accept a scalar rather than a column "'Table'[date]", as a result, we need to use a Aggregate function to change the column to a value.

But don't be worried about this, actually, in this scenario, only one value in the column "'Table'[date]" becuase it has been filtered by the table visual, as a result, SUM(), MIN(), MAX() can get the same result.

Best Regards,

Teige

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    TeigeGao thx for the explanation