Forum Discussion
JAVED
Helper I
Helper Iregarding display date
Hi! I have product column, date column and price column i need to divide the price column as start price and end price Start price the startingprice of the product in a period and end price is the ...
Hi JAVED,
You can create measures below:
StartPrice = CALCULATE(MIN('Table1'[price]),FILTER(ALL(Table1),'Table1'[Product]=MAX('Table1'[Product])))
EndPrice = CALCULATE(Max('Table1'[price]),FILTER(ALL(Table1),'Table1'[Product]=MAX('Table1'[Product])))
No.Revisions = var t=SUMMARIZE('Table1','Table1'[Product],'Table1'[date],"p",MAX('Table1'[price]))
return
COUNTX(t,[p])-1Please see attached pbix file.
Best Regards,
Qiuyun Yu
JAVEDHelper I
Helper I| price | date | Product |
| 3972286.6 | May, 2016 | MOULDING ASSY |
| 4011542.6 | May, 2016 | GARNISH ASSY |
| 4052032.36 | May, 2016 | CLOTH RR |
| 3960105.32 | May, 2016 | T-SCREW |
| 3920401.32 | May, 2016 | PAFL PAD |
| 3999071.96 | May, 2016 | HA PAD |