Forum Discussion

1984's avatar
1984
Helper I
2 years ago
Solved

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 loo...
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.