Visual Matrix: Mask blanks with " - " or anyother but should not enter in the calculation

Hi,

The above problem arise because your data model does not contains a date table .(you forget to mark your date table as date table )
Now its showing the expected result:
image

Attaching pbix for your refrence:
example V2.pbix (142.1 KB)

You can visit the below link for creating your date table:

Thanks,
Anurag

1 Like