Forum Discussion

lisapduan's avatar
lisapduan
Frequent Visitor
1 year ago
Solved

Issue with calculated date range

I have a report I'm trying to modify. There is a memo field on the report that needs to contain a date range based on what dates have been entered into the date slicer. The correct range of dates are...
Need Help
  • V-yubandi-msft's avatar
    V-yubandi-msft
    1 year ago

    Hi lisapduan ,

    Apologies for any earlier inconvenience. Our testing confirms that the date range logic functions as intended and meets your original requirements.

     

    FYI:

     

     

     

     

     

    From your latest message, it seems a particular relationship in your data model is affecting the date context flow. This explains why the logic worked correctly when that specific table was removed.

    While the DAX solution is robust, you may need to adjust your model setup slightly to ensure everything aligns perfectly.

     

    I have also attached a .pbix file containing a simplified example of the working logic for your reference.

     

    Regards,

    Yugandhar.

     

Deku's avatar
Deku
Super User
1 year ago

Is it a separate dimension or a date field in the same table?

lisapduan's avatar
lisapduan
Frequent Visitor
1 year ago

Date field in the same table

  • V-yubandi-msft's avatar
    V-yubandi-msft
    Community Support
    1 year ago

    Hi lisapduan ,

    Replace  YourTable [Date] with the actual table/column name.
    Then, utilize this measure in your memo field display.

    If you continue to encounter the "Query has exceeded available resources" error.

    1. First, test it using a card visual  and Avoid using it directly in high row-level detail visuals like tables or matrices. Instead, create this measure at the page/report level and display it above the table.

    Thank you Deku , for your response.

     

    Thank You.