Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Last month and Last Week DAX Formulas

Hi There,   I am fairly new to power BI and trying to figure this out.. I want to create a date table that will have a series how collumns that show a "Yes" or "No" value based on specfied date ran...
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Xioxin,

     

    Thanks for the reply. I tried that and still get the same error.

     

    The "," is working when I use it in other formulas. Example this works:

     

    Yesterday =
    IF (
    YEAR ( [Date] ) = YEAR ( TODAY () )
    && DAY ( [Date] ) = DAY ( TODAY () -1 ),
    "Yes",
    "No"
    )

     

     

kwatson1's avatar
kwatson1
Frequent Visitor
3 years ago

Greg_Deckler , Mich I was unable to get this to work as written above, but was able to adjust the parenthises in the formula to get it to work:

B_MEAS_SchedLastWeek =
IF (
YEAR ( [StartDate].[Date] ) = YEAR ( TODAY () )
&& WEEKNUM ( [StartDate].[Date] ) = WEEKNUM ( TODAY() ) -1,
"Yes",
"No"
)