topic Re: Dax Measure Help in DAX Commands and Tips

Dax Measure Help

1984 — Wed, 19 Jun 2024 15:36:30 GMT

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 🙂

Re: Dax Measure Help

lbendlin — Thu, 20 Jun 2024 01:18:16 GMT

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/1447523

Re: Dax Measure Help

Anonymous — Thu, 20 Jun 2024 01:39:54 GMT

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.