Get value on date

[Anonymous]

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!

[v-yuta-msft]

@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]

@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.