Forum Discussion

mailwin33's avatar
mailwin33
Frequent Visitor
9 years ago

Calculate maximum time with grouping earlier rows

Hello, everyone! I stucked with writing a DAX formula that I can't manage to during the week. I have a table that contains data about guests visited our building (with electronic cards. Also we hav...
Need Help
Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
9 years ago

mailwin33

 

Change Max instead of Values in Var declaration

mailwin33's avatar
mailwin33
Frequent Visitor
9 years ago

Vvelarde

 

With MAX instead VALUES works, but display max BuildingExitTime for the day (as my formula did), not for the each group.

  • Vvelarde's avatar
    Vvelarde
    Icon for Community Champion rankCommunity Champion
    9 years ago

    mailwin33

     

    Are you using a measure to this?.

     

    Look i change the values for Max and still work

  • mailwin33's avatar
    mailwin33
    Frequent Visitor
    9 years ago

    Vvelarde

     

    Hmm, now I tried to create MEASURE again and it only rolls the load indicator and extremely consume my CPU.

    Actually my table contains almost 1 million rows. I set the EnterDate filter for today, but data still loading.

    Can I accelerate the request?