Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Calculated column to count rows per period

I have two tables, Account with their created date and a financial period table/Calendar with Quarters start and end date columns. The two tables are not linked.   I'm trying to calculate infront ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

     

    You can create a new table visual and drag 'Finance Period'[PeriodStartDate], 'Finance Period'[PeriodEndDate] and this measure into the table visual.

     

    New Customers = 
CALCULATE (
    COUNT ( 'Account'[Id] ),
    'Account'[CreatedDate] >= MAX('Finance Period'[PeriodStartDate]),
    'Account'[CreatedDate] <= MAX('Finance Period'[PeriodEndDate])
)

     

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

 

You can create a new table visual and drag 'Finance Period'[PeriodStartDate], 'Finance Period'[PeriodEndDate] and this measure into the table visual.

 

New Customers = 
CALCULATE (
    COUNT ( 'Account'[Id] ),
    'Account'[CreatedDate] >= MAX('Finance Period'[PeriodStartDate]),
    'Account'[CreatedDate] <= MAX('Finance Period'[PeriodEndDate])
)

 

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data