Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Set a conditional flag

Hello!   I have a table where I have data on vehicle positions (vehicle id, time of sending their last position, longitude and latitude). I need to set up an active/inactive indicator (calculated c...
Need Help
  • PC2790's avatar
    PC2790
    4 years ago

    I mean use the given dax formula to create a calculated column in your table.Is that what you are doing?

    Home-->New column-->Paste the code there

    The error is because you are using it as a measure.

PC2790's avatar
PC2790
Icon for Community Champion rankCommunity Champion
4 years ago

Hey Anonymous ,

 

How does your sample data look like?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Here is a sample of my data PC2790 

     

     

    In this sample, the vehicles moved each time, so they are considered active.

     

    But let’s imagine that the first line is duplicated with a different schedule, (the 04/07/2022 at 07:05:00 with the same longitude and latitude for example), the vehicle should therefore be marked as inactive for this newline

     

    • PC2790's avatar
      PC2790
      Icon for Community Champion rankCommunity Champion
      4 years ago

      Hey Anonymous ,

       

      Is this what you are looking for?

      Active/Inactive = 
var previousval = Calculate(Max(VehicleTb[PositionTimestamp]),Filter(VehicleTb,VehicleTb[PositionTimestamp]<Earlier(VehicleTb[PositionTimestamp])),ALLEXCEPT(VehicleTb,VehicleTb[Vehicle ID]))
var previouslong = CALCULATE(Max(VehicleTb[Long]),VehicleTb[PositionTimestamp] = previousval)
var previouslat = CALCULATE(Max(VehicleTb[Lat]),VehicleTb[PositionTimestamp] = previousval)
return
//previousval
if(VehicleTb[Long] = value(previouslong) && VehicleTb[Lat] = value(previouslat),"InActive","Active")
      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        This seems perfect.

         

        However, I don’t understand why certain fields are greyed out and not taken into account. Can you help me debug the formula PC2790 ?