Forum Discussion

RAFIFFF's avatar
RAFIFFF
Regular Visitor
4 years ago
Solved

Max date is not working

Hi Team i am using data range slicer in report i need to clalculate sum of sales of max date of slicer like (30-09-2022) CALCULATE(SUM(Query1[Gross Gen (incl NC Gen) Day - (MU)]),FILTER((Qu...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    I am not sure if I correctly understood your question, but please check the below measure whether it suits your requirement.

     

    new measure: =
VAR _maxdate =
    MAX ( Query1[Report Date] )
RETURN
    CALCULATE (
        SUM ( Query1[Gross Gen (incl NC Gen) Day - (MU)] ),
        Query1[Report Date] = _maxdate
    )
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

Hi,

I am not sure if I correctly understood your question, but please check the below measure whether it suits your requirement.

 

new measure: =
VAR _maxdate =
    MAX ( Query1[Report Date] )
RETURN
    CALCULATE (
        SUM ( Query1[Gross Gen (incl NC Gen) Day - (MU)] ),
        Query1[Report Date] = _maxdate
    )