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((Query1),Query1[Report Date]=[maxdate])) 
I tried by above dax by taking maxdate and add into filter .
but i am unable to get this max date sale.Can you please help.
  • 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
    )

1 Reply

  • 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
    )