Forum Discussion

saud968's avatar
saud968
Memorable Member
5 years ago

Getting the count by Date

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 d...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
v-xulin-mstf's avatar
v-xulin-mstf
Community Support
5 years ago

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's avatar
    saud968
    Memorable Member
    5 years ago

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

    • v-xulin-mstf's avatar
      v-xulin-mstf
      Community Support
      5 years ago

      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's avatar
        saud968
        Memorable Member
        5 years ago

        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