Forum Discussion
Dax Measure Help
Hi
Im hoping someone can help. I have two tables linked by relationship using date. In the fact table I have an Name column and a date column, and the related table is my dates table.
Im looking for a measure that I can add to a matrix that will show me the no. of name in each calendar month?
Please let me know if I need to supply more details for anyone
Thanks for you help 🙂
Hi 1984 ,
lbendlin , thanks for your concern about this case. I tried to create a sample data myself based on the user's requirement and implemented the result. Please check if there is anything that can be improved. Here is my solution:
1. According to your description, I created two tables and created a relationship between them.
2. Create a measure to get the count of each month name.
Count of Names by Month = CALCULATE(COUNT('financials'[Month Name]),'financials')If this is not the result you expected, please tell me more details so that we can better help you solve the problem.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi 1984 ,
lbendlin , thanks for your concern about this case. I tried to create a sample data myself based on the user's requirement and implemented the result. Please check if there is anything that can be improved. Here is my solution:
1. According to your description, I created two tables and created a relationship between them.
2. Create a measure to get the count of each month name.
Count of Names by Month = CALCULATE(COUNT('financials'[Month Name]),'financials')If this is not the result you expected, please tell me more details so that we can better help you solve the problem.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
