ahmedismailfourtex
Board Regular
- Joined
- Apr 28, 2015
- Messages
- 124
hello,
I have sales table like this.
<tbody>
</tbody>
and I need to have column of sales in previous week, so I can calculate the variance of any specific product. I am using Power BI.
can I get help ?
Thanks
I have sales table like this.
product | week | sales |
x | 1 | 10 |
y | 1 | 15 |
z | 1 | 20 |
x | 2 | 20 |
y | 2 | 10 |
z | 2 | 15 |
<tbody>
</tbody>
and I need to have column of sales in previous week, so I can calculate the variance of any specific product. I am using Power BI.
can I get help ?
Thanks