Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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
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
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 |
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!!
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!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
45 | |
26 | |
22 | |
12 | |
7 |
User | Count |
---|---|
73 | |
51 | |
45 | |
16 | |
12 |