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
@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.
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
Fabric Community Update - January 2025
Find out what's new and trending in the Fabric community.
| User | Count |
|---|---|
| 143 | |
| 74 | |
| 63 | |
| 51 | |
| 47 |
