I want to display the previous month and year with conditions

[Anonymous]

The following command works fine while adding a new column

FORMAT(EOMONTH(DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW())),-1), "MMMM-YYYY")

But when I try to use it like this 

Check Empty = 
IF(ISBLANK('August''2020'[LSA]),(IF(ISBLANK('August''2020'[Description of the Change]),"*For the month of "& (FORMAT(EOMONTH(DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW())),-1), "MMMM-YYYY"))  & ", there were no compliant based Cos."), " "))

It displays 

Operator or expression '( )' is not supported in this context.

What's happeing? And how to remove this?

[amitchandak · Accepted solution]

@Anonymous , You can use date table and time intelligence

example

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))

last year MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-12,MONTH)))
last year MTD (complete) Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH(dateadd('Date'[Date],-12,MONTH))))
Month behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Month))
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

[AllisonKennedy]

@Anonymous yes, I think there was a missing bracket near the end, though I also removed some of the extra brackets that were unnecessary 

[AllisonKennedy · Accepted solution]

You have a syntax error in it. Daxformatter.com is a great site for formatting your code: 

Not sure if this is what you're looking for: 

Check Empty =
IF (
    ISBLANK ( 'August''2020'[LSA] ),
    IF (
        ISBLANK ( 'August''2020'[Description of the Change] ),
        "*For the month of "
            & FORMAT (
                EOMONTH ( DATE ( YEAR ( NOW () ), MONTH ( NOW () ), DAY ( NOW () ) ), -1 ),
                "MMMM-YYYY"
            ) & ", there were no compliant based Cos."
    ),
    " "
)

[Anonymous]

@AllisonKennedy 
Thanks for the help and providing such a great resource(DAX Formatter). I think I was missing a bracket, right?
Stay Awesome.

[amitchandak · Accepted solution]

@Anonymous , You can use date table and time intelligence

example

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))

last year MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-12,MONTH)))
last year MTD (complete) Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH(dateadd('Date'[Date],-12,MONTH))))
Month behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Month))
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.