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

     

Jihwan_Kim's avatar
Jihwan_Kim
Super 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

    • Jihwan_Kim's avatar
      Jihwan_Kim
      Super User
      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

       

      • kagy100's avatar
        kagy100
        Advocate II
        5 years ago

        Thanks Jihwan_Kim. Ideally, my preference would be DAX but I guess Power Query also does the trick.