Forum Discussion

efilipe's avatar
efilipe
Icon for Helper IV rankHelper 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
Icon for Community Champion rankCommunity Champion
8 years ago

efilipe

 

Hi, Try with:

 

LastDay = IF('Date'[Date]=MAX('Date'[Date]),1,0)

 

Regards

Victor

efilipe's avatar
efilipe
Icon for Helper IV rankHelper IV
8 years ago

Not really :-(

  • Vvelarde's avatar
    Vvelarde
    Icon for Community Champion rankCommunity Champion
    8 years ago

    efilipe

     

    In your sample table what is the most recent day?

     

    VV

     

     

     

     

    • efilipe's avatar
      efilipe
      Icon for Helper IV rankHelper IV
      8 years ago

      09/11/2017 :-)

      • efilipe's avatar
        efilipe
        Icon for Helper IV rankHelper IV
        8 years ago

        DD/MM/YYYY