Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
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
User | Count |
---|---|
86 | |
82 | |
68 | |
66 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |