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

[febish]

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.

[Anonymous · Accepted solution]

@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

[febish]

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

[VahidDM]

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!!

[febish]

Hi @VahidDM 

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

Thanks,

Febish

[VahidDM]

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!!