Forum Discussion
DATEADD function
Hello, I'm having an issue calculating a total. Here is what I'm trying to do. In the end I'm trying to calculate the total for the prior day. If the prior day happens to fall on Sunday, then take th...
Anonymous change your main measure to this:
No Response = CALCULATE ( SUM ( 'Table'[Total] ), 'Table'[Y/N] = "No Response" )
and also make sure your _calendar table is marked as a date table.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡