Forum Discussion

khush19's avatar
khush19
Icon for Resolver I rankResolver I
5 years ago

Filter on datetime column sometime work ,sometime not

I am working on report ,where i need to take the amount based on latest datetime. For this i created a measure Total Calculated Amount = CALCULATE(sum(ParkingSessionSA[TotalAmount]),FILTER(Parking...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

khush19 , You expected output is not clear. Max on the row context as good as row values unless there is some logic added

Try

Total Calculated Amount =
var _max =MAXX(ParkingSessionSA,ParkingSessionSA[CurrentTime])
return
CALCULATE(sum(ParkingSessionSA[TotalAmount]),FILTER(ParkingSessionSA,ParkingSessionSA[CurrentTime]=_max))

 

Can you share sample data and sample output in a table format? Or a sample pbix after removing sensitive data.

khush19's avatar
khush19
Icon for Resolver I rankResolver I
5 years ago

HI Amit,

 

I tried the measure you suggested,even that is also not working.

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    5 years ago

    khush19 OK, has to be an issue with your data then. Is this import mode or Direct Query mode or?

    • khush19's avatar
      khush19
      Icon for Resolver I rankResolver I
      5 years ago

      This is PUSH dataset ,where data is pushed to power BI every 5 mins from Azure data factory