Forum Discussion

frittle's avatar
frittle
Icon for Helper II rankHelper II
4 years ago

Dynamic Percentage Change Measure based on Date Hierarchy AND List

Hello everyone,

I would like to implement a dynamic percentage change to my line chart, here is an example of what I'm looking for:


I want to visualize the change in percent from one point in the line chart to another. The visual above is only based on a date hierarchy, my visual uses a date hierarchy and a list of all 5 minute timestamps in a day. I have tried the following measure, but did not get the desired result since I don't know how to incorporate the 5 minute timestamp list into the dax Function:

 

Dynamic Percentage Change = 
VAR CurrentValue = [Last Value final 5 minute stamp]
VAR PreviousValue = 
SWITCH(
    TRUE(),
    ISINSCOPE('Main Date Table'[Datum].[Day]), CALCULATE([Last Value final 5 minute stamp], DATEADD('Main Date Table'[Datum], -1,DAY)),
    ISINSCOPE('Main Date Table'[Datum].[Month]), CALCULATE([Last Value final 5 minute stamp], PARALLELPERIOD('Main Date Table'[Datum], -1, MONTH)))
RETURN
DIVIDE(
    CurrentValue-PreviousValue,
    PreviousValue
)
 

 

This is the result I got in my visual (not conditionally formatted): 

 

Here the setup of the visual (as you can see the X-Axis is made up of a date hierarchy from  main date table and the 5 minute timestamp list, which is a seperate table):

 

Does anybody know how I can integrate the list correctly into my dax measure to get the desired result? Any help is greatly appreciated, thanks in advance.

Best Regards
Leo

 

2 Replies