Forum Discussion

cshashank's avatar
cshashank
Frequent Visitor
9 years ago
Solved

DAX Help: Extract value based on last execution

Hi,   I have a below scenario: Timestamp CaseID CaseTitle Status 8-16-2017 5:00 1 TestCase A Pass 8-16-2017 5:00 2 TestCase B Pass 8-16-2017 5:00 3 TestCase C Pass 8-16-...
Need Help
  • TomMartens's avatar
    TomMartens
    9 years ago

    Hey,

     

    maybe this would be a solution, I'm counting the caseid (distinct count) to get the numbers in this table

    I did not use a measure I just changed the Aggregate function in the visuals pane and renamed the column in the visual

     

    Maybe now I'm getting closer 

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

This should be giving you the desired results since your date col also got time. If not, may be put the time of execution in a seperate col and then group the data based upon date and later by time .

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    9 years ago

    you could also do this cshashank

    create the max date

    (its a measure)

     lastdate = max(Table1[Timestamp])

     

    and then create another measure

    Measure 2 = CALCULATE(COUNTROWS('Table1'), FILTER('Table1', Table1[Timestamp] = max(Table1[Timestamp])))

     

    place them both on a visual

  • cshashank's avatar
    cshashank
    Frequent Visitor
    9 years ago
    • Can you please help me with how to group the data based upon date and later by time?
    • TomMartens's avatar
      TomMartens
      Super User
      9 years ago

      Please forgive my slow thinking, but I have no idea what is do mean by grouping, please provide a visual like so

      And also provide input what approach of the suggestions you are using

      • cshashank's avatar
        cshashank
        Frequent Visitor
        9 years ago

        I just wanted to show Pass/Fail in Pie Chart rather than column chart.