Forum Discussion

dethnass's avatar
dethnass
Icon for Helper I rankHelper I
6 years ago
Solved

highest and lowest pct value

Hello,

 

i want to add my pct formula to show highest pct value and lowest pct value between date.

 

 

my pct formula:

 

GBPUSDFirstDate = Min(GBPUSD[Date])
GBPUSDFirstValue = Calculate(Values(GBPUSD[ Close]), Sample(1,'GBPUSD','GBPUSD'[Date].[Date],ASC))
GBPUSDLastDate = MAX(GBPUSD[Date])
GBPUSDLastValue = Calculate(Values(GBPUSD[ Close]), SAMPLE(1,'GBPUSD',GBPUSD[Date].[Date],DESC))
GBPUSDPCT = CALCULATE((GBPUSD[GBPUSDLastValue]-GBPUSD[GBPUSDFirstValue])/GBPUSD[GBPUSDFirstValue])
 
 
 
my result must be like in screenshot:
 
 
is it possible to make?

Thank you.
 

 

Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi dethnass ,

     

    You may add the custom visual Box and Whisker chart from the AppSource, put the [category] into Axis box of this chart, put the [GBPUSDPCT] into Value box.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    For reference:

     

    https://www.youtube.com/watch?v=qQumL4-jwgw

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies