Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dynamic Rebasing Chart

Hello there,   I found this very similar question but I cant seem to find the solution and figure out how to edit - Old Case    Similar to it, I am using a slicer to show the start and end date f...
Need Help
v-zhenbw-msft's avatar
v-zhenbw-msft
Community Support
5 years ago

Hi Anonymous ,

 

Do you want to display the 100 in the min date?

If yes, we can create a date table and a measure to meet your requirement.

 

1. Create a date table that has no relationship.

 

Date = CALENDAR("2020/1/1","2020/1/31")

 

 

2. Then we can create a measure.

 

Measure = 
var _min = MIN('Date'[Date])
var _max = MAX('Date'[Date])
return
IF(
    MAX('Table'[Date]) = _min,100,
    CALCULATE(SUM('Table'[value]),FILTER('Table','Table'[Date]<=_max && 'Table'[Date] >=_min)))

 

 

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

 

Best regards,

 

Community Support Team _ zhenbw

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

 

BTW, pbix as attached.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi v-zhenbw-msft thank you so much! Although the calculation in your pbix seems to be incorrect? I would expect the higlighted results below if I choose Jan 1 2020 as the Start Date.