Forum Discussion

efilipe's avatar
efilipe
Helper IV
8 years ago
Solved

Identify last day

Hi guys,   I have a date table being constructed like:   Date = ADDCOLUMNS ( CALENDAR (DATE(2017;5;1); TODAY()); "DateAsInteger"; FORMAT ( [Date]; "YYYYMMDD" ); "Year"; YEAR ( [Date] ); "Mon...
Need Help
Tips and Tricks
Tutorial Requests
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    efilipe

     

    Try with this calculated column:

     

     

    Regards

     

    Victor

Vvelarde's avatar
Vvelarde
Community Champion
8 years ago

Hi, try with:

 

LD = If(Store[Date]=Max('Date'[Date]) && Store[Store]="Android";1;0)

 

Regards

 

Victor

efilipe's avatar
efilipe
Helper IV
8 years ago

Nope. It looks like it can't get an unique value

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    8 years ago

    efilipe

     

    Are using a calculated column?

     

    VV

  • efilipe's avatar
    efilipe
    Helper IV
    8 years ago

    Vvelarde i'm trying to resolve on the Stores table with M function. Any idea how to solde the error: 

     

    Expression.Error: Não é possível converter o valor #date(2017, 8, 8) para o tipo List.
    Detalhes:
    Value=08/08/2017
    Type=Type

     

    if [Date] = List.Max([Date]) && [OS] = "Android" then 1 else 0

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    8 years ago

    efilipe

     

    The quick way is share a file without confidential data. 

     

    you can share here or by Private Message. 

     

    Regards

     

    Victor