Forum Discussion

Hacharoui_101's avatar
Hacharoui_101
New Member
3 years ago
Solved

Combining two data with same calendar year into a line chart

Hello guys i am new to power BI. I am trying to get a two line area chart. The data is for predicted and current usage of electricy for the year 2023, i am trying to show both, the predicted and actu...
Need Help
  • eliasayyy's avatar
    eliasayyy
    3 years ago

    Hacharoui_101 however if you can create a table just use the measure

    Sum of Whats from otehr table = CALCULATE(
SUM('your other table'[Whatt]) , 'your other table'[Date] = MAX('your table you are using the axis '[Date])
)
eliasayyy's avatar
eliasayyy
Icon for Memorable Member rankMemorable Member
3 years ago

hello try creating a calendar table with unqiue dates , then create a one to many relationship between the calenadat table and all your otehr tables by the date column then in the x-axis put the desire column from the calendar table

eliasayyy's avatar
eliasayyy
Icon for Memorable Member rankMemorable Member
3 years ago

Hacharoui_101 however if you can create a table just use the measure

Sum of Whats from otehr table = CALCULATE(
SUM('your other table'[Whatt]) , 'your other table'[Date] = MAX('your table you are using the axis '[Date])
)
  • Hacharoui_101's avatar
    Hacharoui_101
    New Member
    3 years ago

    Thanks, this solution worked