Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have an issue that I am not sure how to solve.
The report consist of two dates: expiry date and start date and I have a number of employees per team in a column.
The issue is that I am not sure how to present the numbers of employees when they have exceeded the expiry date.
EG.
Start date 01-01-2018: 5
Expiry date 01-10-2018: -5
How do I change it to be -5 after the expiry date?
@JimmyDQN Could you please explain bit more detail (It will be great if you can provide sample data to test). As per my understanding you need to turn the number into negative value after a particular date ? If that's the case just multiply with "-1" to your value. Sample data and expected output will be helpful to provide an accurate solution.
Proud to be a PBI Community Champion
Hi,
I have inserted an example below. I would like a visualization where the axis is based on months. and then I want
January to have number of members for each team. So for january it would be 105 + 55 + 56 whereas february will show current members (55 + 65 + 45) but also show how many we lost. If you need I can try to make an example in Excel.
Team | Contract | Country | År | Contract Start Date | End date |
1 | 105 | DKK | 2018 | jan | Feb |
2 | 55 | DKK | 2018 | jan | Feb |
3 | 56 | DKK | 2018 | jan | Feb |
1 | 65 | DKK | 2018 | feb | Mar |
2 | 55 | DKK | 2018 | feb | Mar |
3 | 45 | DKK | 2018 | feb | Mar |
1 | 123 | DKK | 2018 | mar | Jul |
2 | 123 | DKK | 2018 | mar | Jul |
3 | 45 | DKK | 2018 | mar | Jul |
1 | 43 | DKK | 2018 | jul | dec |
2 | 23 | DKK | 2018 | jul | dec |
3 | 5 | (tom) | 2018 | jul | dec |
@JimmyDQN Yes please, It will be helpful if you can post the expected output as well.
Proud to be a PBI Community Champion
@PattemManohar I just made a better example:
I would like to create a bar chart based on date.
In January, product 1 will be positive as the contract has not expired, but in the following month, i want that data to be negative, as we have "lost" that money.
Product | Team Owner | Country | År | Contract Start Date | Contracts starting | revuune while contract is active |
Product 1 | Person A | DKK | 2018 | jan-18 | feb-18 | 500 |
Product 2 | Person A | DKK | 2018 | feb-18 | mar-19 | 640 |
Product 3 | Person A | DKK | 2019 | mar-18 | apr-18 | 251 |
Product 4 | Person A | DKK | 2018 | apr-18 | maj-18 | 268 |
Product 5 | Person A | DKK | 2018 | maj-18 | jun-19 | 656 |
Product 6 | Person A | DKK | 2018 | jun-18 | jul-18 | 2418 |
Product 7 | Person B | DKK | 2018 | jul-18 | aug-18 | 21 |
Product 8 | Person B | DKK | 2018 | aug-18 | sep-19 | 298 |
Product 9 | Person C | DKK | 2018 | sep-18 | okt-18 | 2047 |
Product 10 | Person C | NO | 2018 | okt-18 | nov-18 | 22117 |
Product 11 | Person D | DKK | 2018 | nov-18 | dec-19 | 26287 |
Product 12 | Person F | NO | 2018 | dec-18 | jan-19 | 2154 |
Product 13 | Person F | DKK | 2018 | jan-19 | jan-19 | 2356 |
Product 14 | Person D | DKK | 2018 | feb-19 | mar-19 | 2998 |
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |