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

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

 

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

But when I drag the measure : 

Calendar = CALENDAR(MIN(Historique[Report Date]),TODAY())

My table visual do this : 

Sincerely 

 

Luca BOROME  

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous

     

    Attached my simplified sample for your reference.If it is not your case,please share your sample data.You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

     

    Regards,

    Cherie

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi,

       

      I tried your solution again and it worked.

      Thank you for your help.

       

      Sincerely 

       

      Luca BOROME