Forum Discussion

mgrayTCB's avatar
mgrayTCB
Helper IV
1 year ago
Solved

Stuck with Date Problem

The measure below works if I use hard cod dates (shown in red below) but not if I calculate the dates. The date calculations return the dates I want but I get the values for dates in between. I only ...
Need Help
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    1 year ago

    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.

lbendlin's avatar
lbendlin
Super User
1 year ago

What is the expected outcome?  The [Sum Net Rent] for these two days, or for the date range between them?

 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

mgrayTCB's avatar
mgrayTCB
Helper IV
1 year ago

Yes the expected outcome is just  [Sum Net Rent] on the two dates no data on anyother dates.