Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Help with my Targets Values

Hello everyone,   I'm new on the forum and i come from France sorry for my bad english in advance.   Actually im a trainee in an American company and i have to create a Claims Dashboard on Power ...
Need Help
Show and Tell
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi  Anonymous ,

I created some data:

Here are the steps you can follow：

1. Create measure.

Measure =
var _min=MINX(ALLSELECTED('Table'),'Table'[date])
var _max=MaxX(ALLSELECTED('Table'),'Table'[date])
return
MAXX(FILTER(ALL('Table'),'Table'[date]>_min&&'Table'[date]<_max),[date])

2. Result:

Best Regards,

Liu Yang

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hello Anonymous ,

Thanks for your answer.
But i didn't understand how it could help me because that's not what i want. For a Business Unit i want it target for the month selected on a gauge.

Have a nice day !