Forum Discussion
Solved
Lowest Value
Hi, I am trying to create a line on my bar visual like below; But I would like to add a line that displays the lowest value for the past 7 days even say when the date range is anything e...
Hi MrGriff ,
Try the following measure, and then add it to value. Add it in the min line, refer to the following:
Last_7 = CALCULATE ( MIN ( 'Table'[Value] ), DATESINPERIOD ( 'Table'[Date], TODAY (), -7, DAY ) )
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.Best Regards,
HenryIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Below is the sample pbix file.
