Forum Discussion

abc_777's avatar
abc_777
Solution Specialist
2 years ago
Solved

hi

Hello,

 

I have two Measures MAX and MIN. I want simple Max and min values by year and MonthName or MonthInCalendar

 

 

But when i give 

 

VAR _Max_value = MAXX(ALLSELECTED( BMCalendar[Year]) or 

VAR _Max_value = MAXX(ALLSELECTED( BMCalendar[MonthName ]) or 

VAR _Max_value = MAXX(ALLSELECTED( BMCalendar[MonthInCalendar])

 

I cant see anything as Min markers and Max markers

 

but using following measure i got the max markers and min markers

 

 

Max Value =
 VAR _Max_value = MAXX(ALLSELECTED( BMCalendar[Date]),
            [Total in Piece and KG (Measure)]
 )
  VAR _Check = IF(_Max_value = [Total in Piece and KG (Measure)], _Max_value, Blank())
 RETURN
_Check

 

 

 

Can someone help me doing Max markers and min markers by year and MonthName or MonthInCalendar

 

also tell me what should be in----- line chat X-Axis and Y-Axis

 

 

thanks

Need Help

1 Reply