topic Re: Hi, Could you please explain me me how to do a count of column items in particular date period ? in DAX Commands and Tips

Hi, Could you please explain me me how to do a count of column items in particular date period ?

febish — Fri, 29 Oct 2021 19:14:28 GMT

Hi, Please explain me how to do the count of coloumn item in a particlar time period ? and last three days ?

I have a sales data with particlar sales type " Direct", "Inderect", etc. I want to count this based on the time period and MTD.

1) Do I need a sperate Clander table to use the time intelligence functions ?

2) What is the DAX for this

3) Do I need key tables ?

4) What are the parameters I need to choose for a matrix visulization ?

5) How to automate this report ? I want send this automatically on daily once in a particlar time.

Re: Hi, Could you please explain me me how to do a count of column items in particular date period ?

VahidDM — Fri, 29 Oct 2021 22:44:48 GMT

Hi febish

1) Do I need a sperate Clander table to use the time intelligence functions? YES

see this link: https://www.vahiddm.com/post/creating-calendar-table-with-3-steps

2) What is the DAX for this? https://docs.microsoft.com/en-us/dax/totalmtd-function-dax

3) Do I need key tables ? ??

4) What are the parameters I need to choose for a matrix visualization ? It depends on what you want to show on the report

5) How to automate this report ? I want send this automatically on daily once in a particlar time? DAX will calculate the value automatically based on your data

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

Re: Hi, Could you please explain me me how to do a count of column items in particular date period ?

febish — Sat, 30 Oct 2021 09:09:49 GMT

Thank you so much for reply VahidDM

Pease help me how to do the count of a column item (METHOD) for the last three days (refer the sample dats as below).

I need to have DAX formula, as the dashboard need to automated.

Kindly support.

Febish

MethodEntry Date

Direct	10/19/21 10:09 AM
Indirect	10/18/21 10:09 AM
Change	10/17/21 10:09 AM
Direct	10/19/21 10:09 AM
Indirect	10/21/21 10:09 AM
Change	10/16/21 10:09 AM
Direct	10/17/21 10:09 AM
Indirect	10/17/21 10:09 AM
Change	10/19/21 10:09 AM
Direct	10/19/21 10:09 AM
Indirect	10/19/21 10:09 AM
Change	10/18/21 10:09 AM
Direct	10/17/21 10:09 AM
Indirect	10/19/21 10:09 AM
Change	10/21/21 10:09 AM

EXPECTED RESULT

Row Labels	16-Oct-21	17-Oct-21	18-Oct-21
Change	2	4	2
Direct	1	2	0
Indirect	1	6	2
Grand Total	4	12	4

Re: Hi, Could you please explain me me how to do a count of column items in particular date period ?

VahidDM — Sat, 30 Oct 2021 12:21:29 GMT

Do you need dax or just a solution? If you want a solution, add Entry Date to the filter section and set it to show the last 3 days or topN 3.

Appreciate your Kudos!!

Re: Hi, Could you please explain me me how to do a count of column items in particular date period ?

febish — Sat, 30 Oct 2021 13:57:16 GMT

Hi VahidDM

I need a DAX, as this report I need to automate.

Thanks,

Febish

Re: Hi, Could you please explain me me how to do a count of column items in particular date period ?

Anonymous — Tue, 02 Nov 2021 06:37:25 GMT

febish

I somehow cannot get your expect result with the last 3 days logic using, 16th,17th and 18th are not the last 3 days. If you mean you want the earliest 3 days, which is also doesn't make sense because you only have 1 "Change" method on 16th. Please clarify the expect result or correct me if I misunderstood.

Best regards
Paul Zheng _ Community Support Team