Forum Discussion
Data not available
Hi, Please see the image below. I have some data for december. But january data is not available yet. So im hardocding it in the return statement saying if(isblank(result),0, result) Is the...
In my date table I have 4 values, included 202502 feb as well against which there is not even a 0entry in the fact table
Apply ALLEXCEPT to your dates table. I applied that a different table because no sample data was provided and whipped up something for the sake of illustration. Also, your showing 0% in your viz so apply ALLEXCEPT to the same measure as that that is measure you'll want to apply dynamic format string to.