Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I tried different method but without succes
I have a staff table, with the date when entry and the date for thoses who leave the company
I want to show per year on a line charts the evolution of the number of workers being taken on and thoses who are leaving
I link the entry date to a date table and so no problem i have my chart (blue line)
When i try to add in second values the count of leaving it doesnt work i have a straight line
I think it is normal because this date isn't link whith a date table
But i can't link the date with the date table use for the othe line, power pi don't like it 🙂
I try to use mesure ....
I thnk i miss understood how to do it,when it came from the same table
Solved! Go to Solution.
@nicolast29 I guess in the 2nd line you are trying to show count based on out date, if that is the case, make sure the date table has a relationship with out column, it will be an inactive relationship. Add the following measure and use it for the 2nd line.
Out Count = CALCULATE ( COUNTROWS ( YourTable ), USERELATIONSHIP ( DateTable[Date], YourTable[Out] ), YourTablep[Out] <> BLANK() )
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@nicolast29 I guess in the 2nd line you are trying to show count based on out date, if that is the case, make sure the date table has a relationship with out column, it will be an inactive relationship. Add the following measure and use it for the 2nd line.
Out Count = CALCULATE ( COUNTROWS ( YourTable ), USERELATIONSHIP ( DateTable[Date], YourTable[Out] ), YourTablep[Out] <> BLANK() )
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
thanks a lot
It is exacly that i wanted
I will learn deeper the inactive relationship
Have a nice day
User | Count |
---|---|
99 | |
87 | |
80 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |