Forum Discussion

KevinMorneault's avatar
KevinMorneault
Icon for Helper II rankHelper II
2 years ago
Solved

DAX Query - Due by last week - Week Begin on Saturday

Hi Everyone

I am kind fo new to Dax and trying to get my head around it. I need to create a dax query which would provide me records  that are due by last week. 

This is the actual query i have in power query, i am trying to convert into Dax. 

 

DWH_INV_INVESTMENT_SELECT = Table.AddColumn(DWH_INV_INVESTMENT_SELECT_1, "Due by Last Week", each if Date.From([schedule_finish]) < Date.StartOfWeek(Date.From(DateTime.LocalNow()), Day.Saturday) then "Yes" else "No"),

 

 

Need Help

3 Replies

  • KevinMorneault's avatar
    KevinMorneault
    Icon for Helper II rankHelper II
    2 years ago

    Hi All

     

    Here's what i have tried but still has an error, i have tried several approach but so far unsucsseful so far 

     

    Due by last week = IF(DWH_INV_INVESTMENT[schedule_finish].[Date] < DWH_INV_INVESTMENT[schedule_start](TODAY(),2),"Yes","No")

     

     

    • KevinMorneault's avatar
      KevinMorneault
      Icon for Helper II rankHelper II
      2 years ago

      Hi All

       

      Here's another update, this one doesn't produce any error and do generate result but only have no as a result and i should see some Yes, i needed to remove Today() which i would need it, but if i keep it, generate an error

      Here's the updated query

       

      Duebylastweek = IF(DWH_INV_INVESTMENT[schedule_finish].[Date]< DATEADD(DWH_INV_INVESTMENT[schedule_start].[Date],-2,DAY), "Yes","No")