If statement in DAX

[samnaw]

Hi

I am trying to do a if statement.

IF CURRENT(YYYY-MM) = CurrentYearMonth THEN M1

And I want to put that date in a card. 

How can I do this. 

[v-weiyan1-msft]

Hi @samnaw ,

Based on the sample and description you provided,
You can also consider the following code to create a Measure.

Measure = 
MAXX(
    FILTER('insertDatePLCS',[CurrentYearMonth]=FORMAT(TODAY(), "YYYY-MM")),
    'insertDatePLCS'[M0]
)

Result is as below.

Is this the result you expect?
Please correct me if I misunderstood your needs.

Best Regards,
Yulia Yan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[samnaw · Accepted solution]

I did it by creating a column, but I wish i didnt have to create one. 

Created a new column: 

CurrentYearMonthFlag =

Switch( true(),

[CurrentYearMonth]=FORMAT(today(), "YYYY-MM"),"Yes", "No")

DAX statement:

M0Date = CALCULATE

    (SUM(insertDatePLCS[M0]),

        FILTER('insertDatePLCS','insertDatePLCS'[CurrentYearMonthFlag]="Yes"))

[samnaw]

No, I want to insert a card that gives me the date associated with currentYearMonth. With no filters selected. 

[samnaw]

I am still getting the wrong result:

I should be getting "2024-01-01" but I am getting "NULL"

IF ( FORMAT ( TODAY(), "YYYY-MM" ) = SELECTEDVALUE( 'insertDatePLCS'[CurrentYearMonth]), SELECTEDVALUE( 'insertDatePLCS'[M0]),"NULL")

[erickeu]

can you upload a power bi sample file with the page that you are trying to create? 

[erickeu]

i assume you want to compare what's selected on a slicer with the current yearMonth right ?? if so then just create a new measure
MeasureX = IF ( FORMAT ( TODAY(), "yyyy-MM" ) = SELECTEDVALUE( 'YOUR_TABLE_NAME'[CurrentYearMonth]), "A","B")

IF This helps, just mark it down as a solution, thanks 🙂