Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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/On hold by L2 columns are fixed (see capture below)

 

 1.png

 

In addition, I load another table in Power BI ("Fichier à plat en cours") with the same columns as in the " History " table but they are calculated columns (see capture below). However, this table is only used to calculate the Backlog L1/Backlog L2/On hold by L1/On hold by L2 of the day (in my example on 17/01/2019).

 2.png

 

 The objective of this manipulation is to create a visualization with the values of the "History" table with as first line the daily data for the columns calculated Backlog L1/Backlog L2/On hold by L1/On hold by L2.

 

First I created a measure who make the sum of “Backlog L1”:

                                Sum backlog L1 = sum('Fichier à plat en cours'[SP_Backlog_L1])

Then I created this measure:

                       Test backlog L1 = if(SELECTEDVALUE(Historique[Report Date])<TODAY();SELECTEDVALUE(Historique[Backlog L1]);                                                         [Sum backlog L1])

 

But it doesn't work....

3.png

Can you help me?

 

Sincerely

 

Luca BOROME

1 ACCEPTED SOLUTION
v-cherch-msft
Employee
Employee

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

1.png

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-cherch-msft
Employee
Employee

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

1.png

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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 : 

DD.PNG

Sincerely 

 

Luca BOROME  

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

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hi,

 

I tried your solution again and it worked.

Thank you for your help.

 

Sincerely 

 

Luca BOROME

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.