Forum Discussion

KevinMorneault's avatar
KevinMorneault
Helper 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 ...
Need Help
KevinMorneault's avatar
KevinMorneault
Helper 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
Helper 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")
 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi KevinMorneault ,

    Please try:

    Column = IF('DWH_INV_INVESTMENT'[schedule_finish]<(TODAY()-WEEKDAY(TODAY())),"Yes","No")

    Output:

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum