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

Cmcmahan's avatar
Cmcmahan
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Do you have some way of tracking when users enter the system?

 

Because if later you have 1000 users, if you do the calculation for today, you'll have 999 users that didn't message on 4/27/2019.

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Cmcmahan  right now idont have....but we can add a date field, so we know how many users we have each day.