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.

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 ?

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

      This has to be a calculated column. Are you using the DAX in a calculated column?

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        No, these are not calculated columns,
        The different fields work very well in the formula as you can see for positionTimestamp and the same for lontitude and longitude...

         

        I don't unterstand the problem...