Forum Discussion
Power BI Visual Error: "Query Execution Has Exceeded the Allowed Limits" When Using Date Measure
Hello, thank you for your response. In the visual, I am only displaying data from the Sales table, and the Date table is not linked to the Sales table. In the report, I have a slicer for the Date table that is used in the calculation of the measure if the SelectedDate of the slicer is bigger than the Transdate the measure will returns the max of the column Stardate.
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.
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.
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