I have a data sheet that has a list of dates and I need to count how many times those dates show up. Problem is there are some dates that do not show up at all and result in a blank. I need them to show 0 on my visual and I believe the method is to force them to be 0 instead of blank. Is there a measure to force zero for dates?
Try creating a calculate table using dax below:
Column = Table[Data] + 0
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Here's a picture of the visual.
As you can see there's some months not showing anything at all and I'd like to have them display 0 instead, main reason is relative date filtering doesn't appear like it works properly if there's any null or blank dates.
Hi @whysotan ,
what is your measure?
Maybe this helps:
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.