Forum Discussion

_fmigg's avatar
_fmigg
Regular Visitor
6 years ago
Solved

Create a Calculated Column (or one-column table) as VAR using criteria.

Hi,  I'm trying to create a measure that indicates with a 1 or 0 based on the following data:  Year Month 2019 Jan 2019 Feb 2019 Mar 2019 Apr 2019 May 2019 Jun 2019 Jul 2019 Aug 2019 Sep 2019 Oct 2...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    _fmigg try this DAX

     

    Is month found = 
VAR __maxYear = CALCULATE( MAX ( 'Table'[Year] ), ALL() )
VAR __months = CALCULATETABLE( VALUES( 'Table'[Month] ), 'Table'[Year] = __maxYear)
RETURN
COUNTROWS( __months ) + 0
  • parry2k's avatar
    parry2k
    6 years ago

    _fmigg here is the output

     

AlB's avatar
AlB
Community Champion
6 years ago

Hi _fmigg 

If your measure works correctly, you can just get that one-column table with: 

FILTER( VALUES( Table1[Month] ), [isMonthInMaxYear] = 1)

and then use it in a VAR or wherever you need it. If this doesn't work do show the code for the measure as it migt need adjusting

 

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers  Datanaut