Min Value from a group for a particular Month

[BigKev]

Hi All,

Does anyone know how I can get the min value of a group for a particular month, using column calculation?

The column that I want to achieve is the last column (min Value).

Reporting Month	Region	Value	Min Value
Jan-21	Asia	0	0
Jan-21	Asia	0	0
Jan-21	Asia	1	0
Jan-21	Asia	1	0
Jan-21	Asia	1	0
Feb-21	Asia	0	0
Feb-21	Asia	0	0
Feb-21	Asia	1	0
Feb-21	Asia	1	0
Feb-21	Asia	0	0
Jan-21	North America	1	1
Jan-21	North America	1	1
Jan-21	North America	1	1
Jan-21	North America	1	1
Jan-21	North America	1	1
Feb-21	North America	1	1
Feb-21	North America	1	1
Feb-21	North America	1	1
Feb-21	North America	1	1
Feb-21	North America	1	1
Jan-21	Europe	0	0
Jan-21	Europe	1	0
Jan-21	Europe	1	0
Jan-21	Europe	1	0
Jan-21	Europe	1	0
Feb-21	Europe	1	1
Feb-21	Europe	1	1
Feb-21	Europe	1	1
Feb-21	Europe	1	1
Feb-21	Europe	1	1

Cheers,

Kev

[Jihwan_Kim · Accepted solution]

Hi, @BigKev 

Please check the below picture and the sample pbix file's link down below.

Min Value CC =
MINX (
FILTER (
'Table',
EARLIER ( 'Table'[Reporting Month ] ) = 'Table'[Reporting Month ]
&& EARLIER ( 'Table'[Region] ) = 'Table'[Region]
),
'Table'[Value]
)

https://www.dropbox.com/s/bnc5miwav19m2lf/bigkev.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[aj1973]

Hi @BigKev 

You can Quick measures: