Forum Discussion

kagy100's avatar
kagy100
Advocate II
5 years ago
Solved

DAX Assistance Required

Hi Team,   Here is my query:   Table 1         Account Financial Date Financial Value     AB 1/05/2021 35               Table 2         Account  Consumption...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, kagy100 

    Thank you for your feedback.

    Please check the link down below, and please check if I understood your question correctly.

    I could not know which columns to show in the new table.

    I suggest doing this in Power Query Editory.

     

    https://www.dropbox.com/s/0szj5clsk16bc47/PBIFORUM.pbix?dl=0 

     

     

    Hi, My name is Jihwan Kim.

     

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

     

    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

     

Wendeley-North's avatar
Wendeley-North
Resolver I
5 years ago

Go to manage relationships:

Create a new relationship between the two tables, using [Account] as the identifying column.

Using Table 1 as the original table, create 2 new measures:

ConsumptionDate = RELATED ( Table2[Consumption Date] )
ConsumptionValue = RELATED ( Table2[Consumption Value] )

And use these as Values in Table1.

kagy100's avatar
kagy100
Advocate II
5 years ago

Thank you for your kind time and reply. I was hoping to have an output table with the data instead of a measure. Would this be a possibility ? 

  • Wendeley-North's avatar
    Wendeley-North
    Resolver I
    5 years ago

    The proposed formulas for measures should work in a column, actually.

    So: Go to Table1 > New Column > Use the two formulas above