Hello Christian ,
I haven't seen your .pbix, but i think you don't have a good tabular model.
The best practices require to have a calendar table when you want to play with dates ( and in your case you have two dates ).
This calendar table will be linked to your source table by planned date (activate link) and Actual Date (inactive link). To achieve your goal, you have to use USERELATIONSHIP betweeen Actual Date and Calendar date to activate the link in a calculated measure.
You can see more in the linked .pbix
------------------------------
Jean-Luc DJEKE
Ingénieur BI
------------------------------
Original Message:
Sent: May 07, 2022 08:25 PM
From: Christian CHRISTIAN
Subject: Get planned and actual value per month
Hi,
I need help, I am new on power BI. I have this table. If I create slicer based on the first column I could not get planned and actual value for April. I would like to get simultaneous for april planned value and actual value when I choose April. How please? Thank
you
| Planned date | Planned qty | actual date | Actual qty |
| 04/01/2022 | 10 | 04/05/2022 | 10 |
| 04/02/2022 | 20 | | |
| 05/01/2022 | 20 | 04/05/2022 | 20 |
| 05/03/2022 | 30 | 04/01/2022 | 30 |
I vwould like to get this result
| Month | Planned qty | Actual qty |
| April | 30 | 60 |
| May | 50 | 0 |
| Total | 80 | 60 |
------------------------------
Christian CHRISTIAN
Planning and Project Engineer
------------------------------