How to not show actual blank months when you do +0 to show blank as zero?

[tyw214]

The simple trick to return blanks as 0 is to +0 at the end of an expression, but I run into a problem that my date table starts 1/1/2020 but, my data actually starts in July.

So when i do a calculate(sum(col_1)) + 0 it shows Jan through Jun as well and not start in July.

I tried do a visual filter on it but it still doesnt work. anybody have a solution for this?

[TomMartens]

Hey @tyw214 ,

you can do the following.

1. determine the min date in your facttable using this DAX statement: CALCULATE( MIN( 'facttable'[date] ) , ALL( 'calendartable' ) )
2. check if the current date is greater than or equal to the min date from the previous step, if yes add +0 otherwise don't

Hopefully this provides what you are looking for.

Regards,

Tom

[tyw214]

this seems to only work if there is an actual placeholder month on the 'facttable' to begin with. so it works when you have actual placeholder dates in like july, aug, sept, with no data. But it doesn't work if the sept/oct doesn't exist in the facttable to begin with it seems.

hmm i wonder if there is another solution.

[v-yiruan-msft]

Hi @tyw214 ,

It may need you to provide the applied fields/measure on visual and the related formula of measure in order to find the cause of problem faster. It is better if you can provide the related screenshot(include sample data, applied fields on visual etc.). Thank you.

Best Regards