Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Get value on date

Hello,

I’m new on Power BI and need some help.

I have 2 tables: HIST (historical tarif of articles) and ART (Existing articles).

HIST

    

ORDERS

 

ARTNR

TARIF

DATE

YYYYMM

 

ARTNR

DESCRIPTION

A

5

31/03/2018

201803

 

A

Article A

A

4,5

31/12/2018

201812

 

B

Article B

A

6

31/03/2019

201903

 

C

Article C

B

10

30/09/2018

201809

   

B

11

31/12/2018

201812

   

C

30

30/06/2018

201806

   

 

I need to create an evolution of the tarifs, the table REPORT woudl be my result:

REPORT

     

ARTNR

DESCRIPTION

201812

201901

201902

201903

A

Article A

4,5

4,5

4,5

6

B

Article B

11

11

11

11

C

Article C

30

30

30

30

 

Someone any idea?
Your help would be highly appreciated!

Need Help

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    Anonymous ,

     

    In query editor, click Transform-> Pivot Column as below:

     

     

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      v-yuta-msft 

      Thank you for the reply, but this will not work because I do not have a row for each YYYYMM I need.

      For article C there's no value on 201812 so the value of 201806 must be shown.

      The tarif is valid from, until a new line is created.