Forum Discussion
All Function
Hi all , Max Date new 3 =
CALCULATE(
MAX('Date'[Date]),
FILTER('Date',[Total solar Generated] >= 0.1),
ALL('Date'),
ALL('NGD'[Meter Name (groups)]))
...
Try this
Max Date new 3 =
IF(
HASONEVALUE('NGD'[Meter Name (groups)]),
DATE(2023, 10, 31), -- Replace with the desired fixed date
CALCULATE(
MAX('Date'[Date]),
FILTER('Date', [Total solar Generated] >= 0.1),
ALL('Date'),
ALL('NGD'[Meter Name (groups)])
)
)
Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!