I was wondering how you would input a string of text into a new column if submission date is between two dates (or greater than start date and smaller than end date).
I've heard about datesbetween, but the syntax seems to mention CALCULATE, and I'm not calculating anything, just trying to filter for if the submit date is late or not. (Visual date slicers would be too tedious as well).
from the screenshot you posted it's clear that you are looking for a solution in M meaning Power Query.
The formula has to look similar to this:
if [Datum] >= [ShiftStart] and [Datum] <= [ShiftEind] then "this" else "that"
Just use the column reference [Submitted On] after the and.
The functions DATESBETWEEN and CALCULATE are DAX functions, even if both Power Query / M and DAX are able to create a calculated column that can be used for filtering in the final data model, they are different and both have their own subtleties. In this specific case it does not matter if you use Power Query / M or DAX.
Hamburg - Germany If I answer you question, please mark my post as solution, this will also help others. Proud to be a Datanaut!
@Zubair_Muhammad My apologies, I accidentally switched the two - but I do have another follow-up question about inclusivity - adding the equal signs to make it "greater / less than or equal to" doesn't seem to include submissions as on time if they submitted on the last day of the date range?