Forum Discussion

CMOLINA's avatar
CMOLINA
Frequent Visitor
2 years ago
Solved

Calculate Price Base in a Column

I have this problem to calculate Price divide Base

This issue is when the column "Rango Tamaños" is order by another column

 

I need calculate Index Price but  my calculate works with the base

 

 

 

thanks

 

Need Help
Tips and Tricks
  • Ahmedx's avatar
    Ahmedx
    2 years ago

    pls try this

    Index Price YTD =
VAR _price= [YTO PRICE VOL]
ver _price_base = CALCULATE([YTO PRICE VOL], 'CATALOG'(Rango TamaAos]="501-1000")
RETURN
DIVIDE(_price, _prlce_base) 
------------------or--------
Index Price YTD =
VAR _price= [YTO PRICE VOL]
ver _price_base = CALCULATE([YTO PRICE VOL], FILTER(ALL('CATALOG'),'CATALOG'(Rango TamaAos]="501-1000")
RETURN
DIVIDE(_price, _prlce_base)

4 Replies

    • CMOLINA's avatar
      CMOLINA
      Frequent Visitor
      2 years ago

      Hi Ahmedx  this is the result than will expect:

      the relation between prices in each "Range" vs "Range 501-1000"

  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    2 years ago

    pls try this

    Index Price YTD =
VAR _price= [YTO PRICE VOL]
ver _price_base = CALCULATE([YTO PRICE VOL], 'CATALOG'(Rango TamaAos]="501-1000")
RETURN
DIVIDE(_price, _prlce_base) 
------------------or--------
Index Price YTD =
VAR _price= [YTO PRICE VOL]
ver _price_base = CALCULATE([YTO PRICE VOL], FILTER(ALL('CATALOG'),'CATALOG'(Rango TamaAos]="501-1000")
RETURN
DIVIDE(_price, _prlce_base)
    • CMOLINA's avatar
      CMOLINA
      Frequent Visitor
      2 years ago

      HI Ahmedx. thanks for your code
      I modified a little bit:

      Index Price YTD =
       var _price = [YTD PRICE VOL]
       var _base= CALCULATE([YTD PRICE VOL], FILTER(ALLSELECTED('CATALOG'),'CATALOG'[Rango Tamaños]="501-1000"))
       RETURN
      DIVIDE(_price, _base)

      And it works!!!