Forum Discussion
If Condition Performance Issues
I had to use a filter with IF condition. It is not performing and report fails. With out the filter the report runs fine. Filter = if(and(SELECTEDVALUE('Table [Column])>=DATE(YEAR(TODAY()), MONTH(...
We are on Fabric with schematic model.
Hi rajk,
Perhaps you can try to use IN operator to check if the current date are included in specific ranges:
formula =
VAR currDate =
MAX ( 'Table1'[Column] )
VAR _range =
CALENDAR ( DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ) - 3, 1 ), TODAY () - 1 )
RETURN
IF ( currDate IN _range, "Yes", "No" )The IN operator in DAX - SQLBI
If the aboe not help, can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng