Forum Discussion
Stuck with Date Problem
Thankyou, lbendlin, for your response.
Hi mgrayTCB,
We appreciate your question on the Microsoft Fabric Community Forum.
We kindly request you to provide sample data that clearly demonstrates your issue or query in a structured format (not as an image) to help us understand and resolve the matter. Please ensure that the data is relevant, free from any sensitive information, and directly related to the issue. Additionally, please share the expected outcome based on the given example.
Thank you.
I think I isolated the problem but I am still stuck. Below is the desired result. The megenta line connects the max date with the date 5 minutes earlier. It works fine if I hard code the max date.
The problem happens when I try to harvest the user selected max date and use that to count backwards to the min date. I end up with all the dates in 2025.
As you can see my harvested ddate is picking up the correct date. (retured _dmax below to varify).
Sorry about the screen shots. Cant think of a way to simplify and sanitize the model for sharing.