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

     

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous,

 

It seems like your system not support ',' as separator, you can try to use ';' to instead ','.

 

Regards,

Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
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"
)

 

 

  • Mich_J's avatar
    Mich_J
    Frequent Visitor
    7 years ago

    Helo, Correct formula below -there was an extra ) next to today

    Last Month =
IF (
YEAR ( [Date] ) = YEAR ( TODAY () )
&& MONTH( [Date] ) = MONTH( TODAY () -1 ),
"Yes",
"No"
)

    Last Week =
    IF (
    YEAR ( [Date] ) = YEAR ( TODAY () )
    && WEEKNUM ( [Date] ) = WEEKNUM ( TODAY () -1 ),
    "Yes",
    "No"
    )