Forum Discussion

sw123's avatar
sw123
Helper III
2 years ago
Solved

Use only last value

Hi,   I have a table that looks like this: Date Item Amount Event 14.5.2024 A 2607,09 A 14.5.2024 A 2285,214 B 14.5.2024 A 2090,322 C 14.5.2024 B 9750 A 14.5.2024 ...
Need Help
  • ddpl's avatar
    ddpl
    2 years ago

    sw123 Cerate Measure as per below and use as filter

    Measure = SWITCH(
        TRUE(),
        MAX('Table (4)'[Date]) = MAX('Table (4)'[Date]) && MIN('Table (4)'[Event]) = "A", 1,0 )

     

     

     

     

     

     

Anand24's avatar
Anand24
Super User
2 years ago

sw123 ,
How are you determining the first value for a day if time is not available in the data? What should be the expected output for the sample data you provided?