Put date values in column in table to get count of different date category.

[Anonymous]

Hi,

I would like to make table to count the numbers of each date by month. 

I have separate date table and data table below. 

How can I put data in column in table not to affect each date columns?

If I make relationship or put, for example, Contract Date then other dates are not being calculated by their value, it is being calculated as per its contract date. 

[v-lgarikapat]

Hi @Anonymous ,

Thanks for reaching out to the Microsoft fabric community forum.

@Praful_Potphode 

Thanks for your prompt response

@Anonymous 

I wanted to follow up and confirm whether you’ve had the opportunity to review the information  provided by @Praful_Potphode  If you have any questions or need further clarification, please don’t hesitate to reach out.

We appreciate your engagement and thank you for being an active part of the community.

Best regards,
Lakshmi.

[v-lgarikapat]

Hi @Anonymous ,

We’d like to confirm whether your issue has been successfully resolved. If you still have any questions or need further assistance, please don’t hesitate to reach out. We’re more than happy to continue supporting you.

We appreciate your engagement and thank you for being an active part of the community.

Best Regards,
Lakshmi.

[v-lgarikapat]

Hi @jeongkim ,

We’d like to confirm whether your issue has been successfully resolved. If you still have any questions or need further assistance, please don’t hesitate to reach out. We’re more than happy to continue supporting you.

We appreciate your engagement and thank you for being an active part of the community.

Best Regards,
Lakshmi.

[Praful_Potphode · Accepted solution]

Hi @Anonymous 

userelationship keyword need two columns connected in a relationship(active/inactive doesnt matter)

connect sales recognition date to Date ,the first error will be gone.

[Praful_Potphode]

Hi @Anonymous ,

You can create relationship between your date table and data table.first relationship will be active in solid line while the other relationships will be inactive.then you can create measures which can work on these relationship.

For Example,if PaymentCheckedDate is Active relationship and ContractDate is inActive.

Then you can create measures like below:

Count PaymentCheckedDate=Calculate(Count(Table[PaymentCheckedDate]))
Count ContractDate=Calculate(Count(Table[ContractDate]),userelationship(Table[ContractDate],DimDate[Date]))

For Inactive relationships we will use USERELATIONSHIP DAX function which will activate the relationship.for active relationship there is no need.

Please check if above approach is correct else DM me for more details.

[Anonymous]

Hi 

I cannot get what DimDate would be? 

Date[Date] is the column for calendar dates regardless of data in other table and this is in relationship with Contract Date.