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

efilipe's avatar
efilipe
Helper IV
8 years ago

DD/MM/YYYY

Vvelarde's avatar
Vvelarde
Community Champion
8 years ago

efilipe

 

Try with this calculated column:

 

 

Regards

 

Victor

  • efilipe's avatar
    efilipe
    Helper IV
    8 years ago

    Thanks for being awsome! :-)

  • efilipe's avatar
    efilipe
    Helper IV
    8 years ago

    Vvelarde

     

    I had to alter the filter, but I'm getting an error. Any idea? :-)

     

    I want to get the last day when SO is Android. :-)

     

    LastDayAndroid = IF('Date'[Date] = Max('Stores'[Date]) && 'Stores'[OS] = 'Android';1;0)

    • 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