Table cannot be used in Computations

Anonymous · ‎08-26-2022

I have received the following error after attempting to produce a date at which the forecasted points reach the estimated points in the calculated table.

==>

My table is shown below. I have tried to go around the problem by indicating whether the conditions are met by displaying a "1."

At the top right, I am attempting to only show the first date in which those conditions are met but can't seem to get the visual to only show the intercepting date. In fact that visual has just been scrolled to show an example of what I hope to produce.

Here is the line of DAX that is giving me trouble because this entire table is built on measures, rather than from the source table.

How can I go about only showing that single date in a card so that we won't have to force people to scroll down to the first 1 in the particular column they are looking at?

Thank you in advance.

Ashish_Mathur · ‎08-26-2022

Hi,

Share the link from where i can download your PBI file.

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

parry2k · ‎08-26-2022

@Anonymous what is the table you are showing in the image?

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.