Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Filter by values that do not yet exist

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!

1 Reply

  • Shaurya's avatar
    Shaurya
    Icon for Memorable Member rankMemorable Member
    3 years ago

    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