How to create a measurement to act like an if statement?

[gusdahu]

Hello,

Currently I am using direct SQLto upload data into Power BI. As you all know, direct SQL disables many of Power BI's functionalities such as creating conditional columns among others. How may I create an if statement in Power BI using the measurement feature to compare two dates? Basically I have a PO Date and an Invoice date. I would like the measure to count the number of instances the invoice date is prior to the PO date.

Any help would be much appreciated.

Regards,

Gus Dahu

[v-yulgu-msft · Accepted solution]

Hi @gusdahu,

Please try below measures:

check = IF(MAX(Table1[Invoice date])<MAX(Table1[PO Date]),1,0)
count = CALCULATE(COUNTROWS(Table1),FILTER(Table1,[check]=1 ))

Best regards,

Yuliana Gu

[gusdahu]

Hi Yuliana,

Thank you for your response!

After I type in the formula into my measurement, should the table automatically populate with a new column for the measurement? I attempted to manually add the measurement to the table, however I get the rejection "Can't display visual. See details". I have no idea what I am doing wrong.

Regards,

Gus Dahu