Getting the count by Date

[saud968]

Need to get the count for the Current week for August and then count since the oldest date

For example, if in August first week has 5 count billing and then the total count should be the oldest date. So current 5 + count from old is 5 so total 10. @AllisonKennedy  @ChrisMendoza @amitchandak  @Greg_Deckler @Jihwan_Kim 

Please help me out

I tried this but it is not giving the correct count 

Open Credit = CALCULATE(COUNT(Credit[Billing Request: Created Date]) + COUNT('Calendar'[Year]))

So instead of 95 as shown below in excel, it is only giving 42

Below is how it looks on excel 

Billing Request: Created Date

10/26/2020

10/26/2020

10/26/2020

10/26/2020

10/26/2020

10/26/2020

10/26/2020

10/26/2020

10/26/2020

10/27/2020

10/28/2020

10/28/2020

10/28/2020

10/28/2020

10/28/2020

10/28/2020

10/28/2020

10/29/2020

10/29/2020

10/29/2020

10/29/2020

10/29/2020

10/29/2020

10/29/2020

10/29/2020

10/30/2020

10/30/2020

10/30/2020

10/30/2020

10/30/2020

10/30/2020

10/30/2020

10/30/2020

08/01/2021

08/02/2021

08/02/2021

08/02/2021

08/02/2021

08/03/2021

08/03/2021

08/04/2021

08/04/2021

08/05/2021

08/05/2021

08/05/2021

08/05/2021

08/05/2021

08/05/2021

[v-xulin-mstf]

Hi @saud968

Not clear about your expected output.

Do you want the count from the earliest date to before the current week?

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[saud968]

@v-xulin-mstf Yes, you are partially right. Basically, I need the count from the earliest date including the current week

[v-xulin-mstf]

Hi @saud968,

Try measure as:

Measure = 
CALCULATE(Credit[Billing Request: Created Date])+CALCULATE(COUNT('Calendar'[Date]),FILTER('Calendar',WEEKNUM('Calendar'[Date])=WEEKNUM(TODAY())))

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[saud968]

@v-xulin-mstf I tried but it not giving the correct output. It should show something similar as per the below image with your measure it is showing 35 current week and open credit also 35

[v-xulin-mstf]

Hi @saud968,

Is your issue solved?

If the issue has been solved, please adopt the solution to help others.

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[v-xulin-mstf]

Hi @saud968,

Just to understand your needs more clearly.

Don't you need a count from the earliest date to the present?

What is the logic of the count for the current week?

Looking forward your reply.

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[saud968]

@v-xulin-mstf if see the previously shared screenshot week 28 credit created is 35 and open credit request is 95...so it is taking the count from the earliest date including week 28

[saud968]

@v-xulin-mstf sorry for the late reply not keeping well for the past few days 😞

the logic is it takes the earliest date for example 08/01/2021 and count from that day till the latest date 09/02/2021... so by that logic it count all the dates from 08/01/2021 including the current week I hope this explains it