Forum Discussion
cumulative count by dates actual vs Planned
Hello,
I'm new to the world of Power Bi and was hoping I could get some guidance on how to calculate the number of scheduled and actual dates by month so that I can build a pivot table where:
lines - company number
columns - days of the month.
I previously found the answer in this post:
https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-Count-by-Date-Actual-vs-Planned/m-p/1544172#M30476
But I couldn’t figure out how to connect 2 columns of one table with a table with dates and use the relationship function.
Any help you can provide is greatly appreciated.Hi voodoo23
Thanks for your concern about this case. lbendlinvoodoo23 For your confusion about how to use the userelationship function, hope the following document will help you.
Using USERELATIONSHIP in DAX - SQLBI
USERELATIONSHIP in calculated columns - SQLBI
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- lbendlin
Super User
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 Hi voodoo23
Thanks for your concern about this case. lbendlinvoodoo23 For your confusion about how to use the userelationship function, hope the following document will help you.
Using USERELATIONSHIP in DAX - SQLBI
USERELATIONSHIP in calculated columns - SQLBI
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
