Forum Discussion

kagy100's avatar
kagy100
Icon for Advocate II rankAdvocate 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

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Hi, kagy100 

Please check the below picture and the sample pbix file's link down below.

 

 

Output Table =
ADDCOLUMNS (
Table1,
"Consumption Date", LOOKUPVALUE ( Table2[Consumption Date], Table2[Account ], Table1[Account] ),
"Consumption value", LOOKUPVALUE ( Table2[Consumption value], Table2[Account ], Table1[Account] )
)
 
 

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