Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Actual Code:
Its giving me the same Max Date against every record
Not too sure why?
Solved! Go to Solution.
@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.
@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.