Minimum Value met on BI report

[Babycakes]

Hi There

I have data in a report 

Staff have a requimrent to get x (minimum) hours per f/n , i have data that shows they are getting x hours

How do I show if it is not met.

Kind regards

[Anonymous · Accepted solution]

Hi @Babycakes ,

According to your statement, I think you want to create a Flag column for Staff based on logic like that somethin meet f/n then Hour >= MinHour (X).

Here I create a sample, in my sample, the logic is that day diff >= 8 (F/N) and MinHour should meet 8 (X).

Flag =
VAR _F_N = 7
VAR _X = 8
VAR _DAYDIFF =
    DATEDIFF ( 'Table'[Start Date], TODAY (), DAY )
RETURN
    IF (
        _DAYDIFF >= _F_N,
        IF ( 'Table'[Hours] >= 8, "Meet Min Hour X", "Not Meet Min Hour X" ),
        BLANK ()
    )

Result is as below.

Best Regards,
Rico Zhou

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

[amitchandak]

@Babycakes , The information you have provided is not making the problem clear to me. Can you please explain with an example.

Min value across selected data

minx(allselected(Table), Table[Hour])

Min after adding it up to a level

Minx(Values(Table[F/N]), calculate(sum(Table[Hour])))

Appreciate your Kudos.