Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.


Create calendar

hello I have a table called FACTURACION_HISPAM, within that there are several columns, Mes_Consumo that has yyyy-mm format, this column tells me the date of the invoice, I have another one called Importe_USD that tells me just the amount, I have another one called Client. I need to know which client and in what month it is not billed. If I make a matrix it tells me that, but it is a huge table, I just want it to show me the clients and that months there are no invoices. If I filter by voids or 0 does not work because in reality that line in the base does not exist. So it does not show anything, the base only has a line if the client has an invoice and indicates the mes_consumo, but if a client was not billed there is no line with the date and the amount 0, it is simply not there, then I can not filter by zeros or empty because in reality that line does not exist. I read that by creating a calendar that contains all the dates of the year after I can relate it to tell me the months and the clients that do not have an invoice.

How can this be done or if there is another way, can you tell me please, thank you.


for example this, if I flitro the year, the country and the type of business, I expect a table that shows me only the gaps, in this case it would be Kubocel in March, Openin in February and March, and ready, that table should not have more


Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors