Forum Discussion
count rows by month without creating relationship
I believe you can create a virtual relationship bewteen tables using the TREATAS function (never used it myself; so far have managed with inactive relationships and USERELATIONSHIP). Sorry I can't be of further help, but might be worth scouting the internet.
Try here for example: TREATAS by enterprisedna.com
Hi,
Create a relationship from the Due Date column of the Data Table to the Date column of the Date Table. In the Date Table, write this calculated column formula to extract the Month: Month = FORMAT(Calendar[Date],"mmmm"). To your visual, drag Month from the Date Table. Write this measure
Measure1 = COUNTROWS(Data)
Hope this helps.
As I mentioned in my first post, is there a way of doing this without creating a relationship, because this screws up the calculations in my original table. Even creating a relationship and leaving it inactive will screw up the calculation
Or do I just need to figure a way of calculating my orignal table differently?
That is really strange that it is messing up your table when you leave it inactive. That is what I would do.
Can I assume you are leaving the relationship with the Task Completion Date active when you create the inactive relationship with the Due Date?
When creating my original table, there were zero relationships in my data model.
