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

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi efilipe,

 

You may try this calculated field formula

 

=if(CALCULATE(MAX(Data[Date]),FILTER(Data,Data[SO]=EARLIER(Data[SO])))=Data[Date],1,0)

Hope this helps.