Table LatDayAndroid and LastDayiOS

[efilipe]

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	Daily Device Uninstalls	Daily Device Upgrades	Total User Installs	Daily User Installs	Daily User Uninstalls	Active Device Installs
21/07/2017		Android	1	0	0	1	1	0	1
22/07/2017		Android	0	0	0	1	0	0	1
23/07/2017		Android	0	0	0	1	0	0	1
24/07/2017		Android	0	1	1	1	0	1	0
25/07/2017		Android	0	0	0	1	0	0	0
26/07/2017		Android	10	3	0	11	10	3	7
27/07/2017		Android	13	3	7	24	13	3	17
29/07/2017		iOS	22
30/07/2017		iOS	18
31/07/2017		iOS	75
01/08/2017		iOS	90
02/08/2017		iOS	58
03/08/2017		iOS	44
04/08/2017		iOS	48
05/08/2017		iOS	27
06/08/2017		iOS	20
07/08/2017		iOS	36
08/08/2017		iOS	56

[Ashish_Mathur]

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.

[efilipe]

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]

@Vvelarde better explained i think 🙂

[efilipe]

@Greg_Deckler help? 🙂

[v-huizhn-msft]

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 

[parry2k]

try this 

Max Flag = var maxDate = Calculate(Max(iOS[Date]), AllExcept(iOS, iOS[SO]) ) return if(maxDate = max(iOS[Date]), 1, 0)

[parry2k]

@Ashish_Mathurwhat is calculated field means? Calculated column or measure?

[Ashish_Mathur]

Hi @parry2k,

It measns measure.

[parry2k]

Thanks for the clarification because calculate field can be very confusing , that is why I asked. 

[Vvelarde · Accepted solution]

@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