Forum Discussion

mayurbajaj's avatar
mayurbajaj
New Member
2 years ago
Solved

Issue with DAX - Returns the same data against every record

Actual Code:

MaxStartDate =
MAXX (
    ADDCOLUMNS (
        SUMMARIZE (
            'Bill Header',
            'Bill Header'[Site Meter Identifier],
            'Bill Header'[Account Number]
        ),
        "MaxBillStartDate", CALCULATE(MAX('Bill Header'[Bill Start Date]))
    ),
    [MaxBillStartDate]
)
 
Output

Its giving me the same Max Date against every record

Not too sure why?

  • mark_endicott's avatar
    mark_endicott
    2 years ago

    mayurbajaj - you can try this:

     

    VAR meter = 
	SELECTEDVALUE( 'Bill Header'[Site Meter Identifier] )
VAR account_num = 
	SELECTEDVALUE( 'Bill Header'[Account Number] )
VAR calc = 
	CALCULATE (
        MAX ( 'Bill Header'[Bill Start Date] ),
        FILTER ( ALL ( 'Bill Header' ), 'Bill Header'[Site Meter Identifier] = meter, 'Bill Header'[Account Number] = account_num )
    )	
RETURN
    calc

     

    If this works, please mark it as the solution. 

1 Reply

  • mark_endicott's avatar
    mark_endicott
    Icon for Super User rankSuper User
    2 years ago

    mayurbajaj - you can try this:

     

    VAR meter = 
	SELECTEDVALUE( 'Bill Header'[Site Meter Identifier] )
VAR account_num = 
	SELECTEDVALUE( 'Bill Header'[Account Number] )
VAR calc = 
	CALCULATE (
        MAX ( 'Bill Header'[Bill Start Date] ),
        FILTER ( ALL ( 'Bill Header' ), 'Bill Header'[Site Meter Identifier] = meter, 'Bill Header'[Account Number] = account_num )
    )	
RETURN
    calc

     

    If this works, please mark it as the solution.