Forum Discussion
Help in POwer BI report
Hi ,
I have 2 columns , 1 columns contains the attributes while the other column contains the value, I want to create a report with a filter of month which is one of the attribute in column 1
I want to create a report that pick the name and Month from column 1 and Previous Sales value from COlumn 2
Please see belwo the table
| Column 1 | Column2 |
| Name 1 | Null |
| Month 1 | Null |
| Previous sale | Value |
| Name 2 | Null |
| Month 2 | Null |
| Previous sale | Value |
Hi,
if you, starting from this
want to get something like this
take a look at the attached file
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
3 Replies
- serpiva64
Solution Sage
Hi,
in power query:
- select colum2
- use fill up
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
- serpiva64
Hi,
if you, starting from this
want to get something like this
take a look at the attached file
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !