Global Power BI User Group

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Calculate table

Jump to Best Answer
  • 1.  Calculate table

    Silver Contributor
    Posted Apr 13, 2019 01:55 AM
    Hi there,
    I have table in Power BI looks like (see attachment) this
    And I wanted to do two things (with slicer for period selected)

    1. show the value of the selected period (but if not bring the most recent one)
    2. Summarize for selected period (include the selected one <= selected.period)

    Thanks,
    Oded Dror

    P.S better explanation

    ------------------------------
    Oded Dror
    ------------------------------


  • 2.  RE: Calculate table
    Best Answer

    Bronze Contributor
    Posted Apr 24, 2019 06:52 PM

    First you need to clean your excel: In the cells where you don't have any value yo need to write "null", also you cannot attache a excel in PBI with different tables in the same sheet

    Second: In PBI do a table with all this information, the of this add some slicers where you relate to the columns you want to filter. 



    ------------------------------
    Alberto Alvarado
    Business Intelligence
    Amado AZ
    5202819233
    ------------------------------



  • 3.  RE: Calculate table

    Silver Contributor
    Posted Apr 25, 2019 07:16 AM
    Alberto,

    Thanks I solve the issue

    Oded Dror



    ------------------------------
    Oded Dror
    ------------------------------