Tyger Guzman Profolio
  • About
  • Resume
    Tyger Guzman

    Tyger Guzman

    Data Analysis with Call Center Background

    • San Antonio, Tx
    • LinkedIn
    • GitHub
    • Email

    Pq relative date

    less than 1 minute read

    Relative Date
    Problem:
        Find Today and Yesterday in Excel Power Query

    Live Day
    if [LoginDate] = List.Max(#"Expanded Fiscal"[LoginDate]) then "TRUE" else "FALSE"

    Previous Day
    if [LoginDate] =Date.AddDays(List.Max(#"Expanded Fiscal"[LoginDate]),-1) then "TRUE" else "FALSE"

    Categories: Excel

    Updated: September 27, 2018

    Share on

    Twitter Facebook Google+ LinkedIn
    Previous Next

    You may also enjoy

    Shpt overtimelist

    less than 1 minute read

    Overtime Sign-Up

    Shpt hidesidenav

    less than 1 minute read

    Hide SideNav

    Shpt downloadfile

    less than 1 minute read

    Download A File

    Shpt cssfile

    1 minute read

    CSS File

    • Follow:
    • Feed
    © 2018 Tyger Guzman. Powered by Jekyll & Minimal Mistakes.