Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Visualization with calculated columns

Hi, I have an issue on Power BI regarding the construction of a visualization. First of all, I load the table "Historique" (excel file) which the values of the Backlog L1/Backlog L2/On hold by L1/O...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Anonymous

     

    You may create a calendar table and then link it with Historique table.Then drag the calendar date and below measure in table visual.

    Calendar = CALENDAR(MIN(Historique[Report Date]),TODAY())
    Test backlog L1 =
IF (
    SELECTEDVALUE ( 'Calendar'[Date] ) < TODAY (),
    SELECTEDVALUE ( Historique[Backlog L1] ),
    [Sum backlog L1]
)

    Regards,

    Cherie