Forum Discussion
Display data till current date only (used items with no data because nature of the data)
Hi,
Here's what i got. PBI file attached.
Super UserMake your straight line measure return BLANK() for all future dates.
I tried to remove the straight line earlier but still couldn't solve the issue
- lbendlin
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/1447523Hi Here is the file you can download. Thanks again for taking time to help me really appreciate it. Also solution above HarishKM provided seems not working for me. I have added that Dax too for the review.
Items-with-no-data-example.pbix
