Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Solved! Go to Solution.
Hi @BBHouston ,
Try this one:
Total = CALCULATE(COUNTROWS('Table'), FILTER(ALL('Table'[Date]), 'Table'[Date] <= MAX'Table'[Date]))
Hi @BBHouston ,
Try this one:
Total = CALCULATE(COUNTROWS('Table'), FILTER(ALL('Table'[Date]), 'Table'[Date] <= MAX'Table'[Date]))
@camargos88THANK YOU! This worked!
Total = CALCULATE(COUNTROWS('Table'), FILTER(ALL('Table'[Date]), 'Table'[Date] <= MAX('Table'[Date]))