Forum Discussion

NT2's avatar
NT2
Frequent Visitor
1 year ago

Power BI Visual Error: "Query Execution Has Exceeded the Allowed Limits" When Using Date Measure

Hello, I need help with an issue in Power BI. I have a visual that includes several columns along with the following measure:       selecteddate = IF(ISBLANK(SELECTEDVALUE('Date'[Date])), TODAY(...
Need Help
AllisonKennedy's avatar
AllisonKennedy
Community Champion
1 year ago

NT2 I can't see why that would be working when no date is selected but time out when you select a date. 

 

Can you try breaking down the measure into parts and see if each part will work? So create some helper measures:

 

Helper1 = MAX('sales'[startdate])

 

Helper2 = SELECTEDVALUE('sales'[Transdate])

 

Helper3 = IF(ISBLANK(SELECTEDVALUE('Date'[Date])), TODAY(), SELECTEDVALUE('Date'[Date]))

 

 

 

Helper4 = SELECTEDVALUE('Date'[Date])

 

 

Test these each individually in your table, see if they return your expected result with a date selected. Let us know your findings. 

NT2's avatar
NT2
Frequent Visitor
1 year ago

Hello, yes the problem is with Helper4 = SELECTEDVALUE('Date'[Date]) when I put it in the visual I got the error, but when I put t in another visual with less columns it works fine.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi NT2 ,

    Whether the problem has been resolved? If yes, could you please mark the helpful reply as Answered? Thank you.

    Otherwise, could you please provide some raw data in your tables(exclude sensitive data) with Text format and the visual settings which the measure [selecteddate] applied on with screenshot? It would be helpful to find out the solution. You can refer the following link to share the required info:

    How to provide sample data in the Power BI Forum

    Best Regards