Forum Discussion

rajk's avatar
rajk
Regular Visitor
2 years ago

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(...
gmsamborn's avatar
gmsamborn
Super User
2 years ago

Hi rajk 

 

Would a measure like this help?

 

Filter = 
    IF(
        SELECTEDVALUE( 'Sheet1'[Date] ) >= EOMONTH( TODAY(), - 4 ) + 1
            && SELECTEDVALUE( 'Sheet1'[Date] ) <= TODAY() - 1,
        "Yes",
        "No"
    )

 

 

Let me know if you have any questions.

 

test IF perf.pbix

 

  • rajk's avatar
    rajk
    Regular Visitor
    2 years ago

    I had same thing but report fails. Even I added dates manually like 12/1/2023 and 3/26/2023, .. But report fails after running for some time. unbale to figure out where the performance issue is. Or an alternative for IF which is better performing.