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 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