Forum Discussion
New Items
Hi, I have data that has UPCs and sales data for them. My data is structured in a way that I have 4 times for data. Latest 4 weeks, latest 13 weeks, latest 26 weeks and latest 52 weeks and for ea...
Can you provide some sample data so we don't have to make something up that doesn't actually fit your request? See links below for how to do that.
How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum
Here it is....
I am guessing that "New" would be when latest 4, 13, 25 adn 52 weeks sales are indential?
| 1 | 77419.92 | SALES | CUR | LATEST 04 WKS |
| 1 | 357.09 | SALES | YAG | LATEST 04 WKS |
| 1 | 173597.4 | SALES | CUR | LATEST 13 WKS |
| 1 | 107383.2 | SALES | YAG | LATEST 13 WKS |
| 1 | 297050.3 | SALES | CUR | LATEST 26 WKS |
| 1 | 140625.6 | SALES | YAG | LATEST 26 WKS |
| 1 | 305715.5 | SALES | CUR | LATEST 52 WKS |
| 1 | 159647 | SALES | YAG | LATEST 52 WKS |
| 1 | 21564 | UNITS | CUR | LATEST 04 WKS |
| 1 | 123 | UNITS | YAG | LATEST 04 WKS |
| 1 | 49824 | UNITS | CUR | LATEST 13 WKS |
| 1 | 34003 | UNITS | YAG | LATEST 13 WKS |
| 1 | 91030 | UNITS | CUR | LATEST 26 WKS |
| 1 | 45082 | UNITS | YAG | LATEST 26 WKS |
| 1 | 93350 | UNITS | CUR | LATEST 52 WKS |
| 1 | 51497 | UNITS | YAG | LATEST 52 WKS |
| 1 | 15.74 | ACV MAX | CUR | LATEST 04 WKS |
| 1 | 1.21 | ACV MAX | YAG | LATEST 04 WKS |
| 1 | 11.86 | ACV MAX | CUR | LATEST 13 WKS |
| 1 | 11.7 | ACV MAX | YAG | LATEST 13 WKS |
| 1 | 11.06 | ACV MAX | CUR | LATEST 26 WKS |
| 1 | 9.12 | ACV MAX | YAG | LATEST 26 WKS |
| 1 | 5.88 | ACV MAX | CUR | LATEST 52 WKS |
| 1 | 5.45 | ACV MAX | YAG | LATEST 52 WKS |
Anonymous , Still not very clear to me
sales = calculate(sum(Table[value]),Table[Meausre]= "SALES" ,Table[Type] ="LATEST 04 WKS")
CUR = calculate(sum(Table[value]),Table[Meausre]= "CUR" ,Table[Type] ="LATEST 04 WKS")new measure =SALES - CUR
