Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dynamic Barchart

I created a calculated column to create the below groups which are split based on the diff in days between one day and today() Below 7 Between 7 and 14 More than 14      I was asked if it...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi Anonymous ,

     

    Please do like this.

    1. Create a "What If Parameter".

    2. Create such a measure.

    Expected Delivery - No subscribed = 
SWITCH(
    TRUE(),
    MAX([Delivered?]) = "Yes" && MAX([Subscribed?]) = "No", 10,
    MAX([Delivered?]) = "No" && MAX([Subscribed?]) = "No" && DATEDIFF(TODAY(), MAX([Expected Delivery Date]), DAY ) <= [Parameter Value], 5,
    MAX([Delivered?]) = "No" && MAX([Subscribed?]) = "No" && DATEDIFF(TODAY(), MAX([Expected Delivery Date]), DAY ) > [Parameter Value], 0
)

     

    Best regards,
    Lionel Chen

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

     

v-lionel-msft's avatar
v-lionel-msft
Community Support
5 years ago

Hi Anonymous ,

 

Please do like this.

1. Create a "What If Parameter".

2. Create such a measure.

Expected Delivery - No subscribed = 
SWITCH(
    TRUE(),
    MAX([Delivered?]) = "Yes" && MAX([Subscribed?]) = "No", 10,
    MAX([Delivered?]) = "No" && MAX([Subscribed?]) = "No" && DATEDIFF(TODAY(), MAX([Expected Delivery Date]), DAY ) <= [Parameter Value], 5,
    MAX([Delivered?]) = "No" && MAX([Subscribed?]) = "No" && DATEDIFF(TODAY(), MAX([Expected Delivery Date]), DAY ) > [Parameter Value], 0
)

 

Best regards,
Lionel Chen

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