Forum Discussion

efilipe's avatar
efilipe
Helper IV
8 years ago
Solved

Table LatDayAndroid and LastDayiOS

Hi guys,   I want to add two columns. First one with the MAX day for Android and second Max day for iOS. And set that column with 1 (true) and 0 (false);   Date   SO Daily Device Installs ...
Need Help
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    efilipe

     

    Hi, ok. Try with this measures

     

    LastDayAndroid =
IF (
    Table1[Date]
        = CALCULATE (
            MAX ( Table1[Date] ),
            FILTER ( ALL ( Table1 ), Table1[SO] = "Android" )
        ),
    1,
    0
)

    To IOS change "Android" to "IOS"

     

     

    Regards

     

    Victor

efilipe's avatar
efilipe
Helper IV
8 years ago

That means that the column "LastDayAndroid" will have value "1" on the line 27/07/2017 and all other "Android" will have 0;

And iOS "LastDayiOS" will have "1" on the line 08/08/2017 and all other iOS lines will have 0;

efilipe's avatar
efilipe
Helper IV
8 years ago

Vvelarde better explained i think :-)

    • Vvelarde's avatar
      Vvelarde
      Community Champion
      8 years ago

      efilipe

       

      Hi, ok. Try with this measures

       

      LastDayAndroid =
IF (
    Table1[Date]
        = CALCULATE (
            MAX ( Table1[Date] ),
            FILTER ( ALL ( Table1 ), Table1[SO] = "Android" )
        ),
    1,
    0
)

      To IOS change "Android" to "IOS"

       

       

      Regards

       

      Victor

    • parry2k's avatar
      parry2k
      Super User
      8 years ago

      try this 

      Max Flag = var maxDate = Calculate(Max(iOS[Date]), AllExcept(iOS, iOS[SO]) ) return if(maxDate = max(iOS[Date]), 1, 0)
      • parry2k's avatar
        parry2k
        Super User
        8 years ago

        Ashish_Mathurwhat is calculated field means? Calculated column or measure?

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      8 years ago

      Hi efilipe,

      Please try the solution other members posted, and mark the right or helpful reply as answer, so more people like will find workaround easily. After I test, all the formulas will return your expected result. Please feel free to ask if you haven't resolved it.

      Best Regards,
      Angelia