Filter by values that do not yet exist

[Syndicate_Admin]

Hello! Using a Direct Query connection, I'm trying to make a dax formula to filter by values that I know aren't present in DB today, but will be in the future; however, when you enter them into the formula and not find them, the visual does not work. Is there a way around this?

Thanks in advance!

[Shaurya]

Hi @Syndicate_Admin,

You can put a condition to check if the value is not blank and perform the rest of the calculations accordingly. That shouldn't give any error.

Did I answer your question? Mark this post as a solution if I did!
Consider taking a look at my blog: Forecast Period - Previous Forecasts