Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I need a little help in creating a calculated column for Yesterday and the Same Day Last Year based of a date column in my orders table.
For example, this column should return true if the date in my date column is either 5/26/2021 or 5/26/2020 (based on the current date) and FALSE otherwise.
Thanks in advance!
Solved! Go to Solution.
Hey @Anonymous ,
try the following approach:
Yesterday or LY =
IF(
myTable[date] = TODAY()-1 || myTable[date] = DATE ( YEAR ( TODAY() -1 ) - 1, MONTH ( TODAY() -1 ), DAY ( TODAY() -1 ) ),
TRUE,
FALSE
)
Hey @Anonymous ,
try the following approach:
Yesterday or LY =
IF(
myTable[date] = TODAY()-1 || myTable[date] = DATE ( YEAR ( TODAY() -1 ) - 1, MONTH ( TODAY() -1 ), DAY ( TODAY() -1 ) ),
TRUE,
FALSE
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |