Club Power BI

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Get planned and actual value per month

    Bronze Contributor
    Posted 17 days ago

    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
    ------------------------------


  • 2.  RE: Get planned and actual value per month
    Best Answer

    Bronze Contributor
    Posted 17 days ago
      |   view attached
    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
    ------------------------------

    Attachment(s)

    pbix
    Actual value.pbix   55 KB 1 version


  • 3.  RE: Get planned and actual value per month

    Bronze Contributor
    Posted 16 days ago
    Hello Jean Luc, Thank you. It works perfectly.

    ------------------------------
    Christian CHRISTIAN
    Planning and Project Engineer
    ------------------------------