Forum Discussion
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 YY...
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.
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.