Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I have 4 tables:
But there could be months with no invoices.
Now I have 2 visualizations:
I need to fill months without data with 0. But the simple
IF(ISNULL([Charges]),0[Charges]))
doesn't do what I need because it puts zeros across the whole date dimension. I need to fill the gaps only between first and last invoicing data.
The second problem with this measure is that it' doesn't filter materials in the second visualization and shows all of them from DimMaterial with zeros.
Could you please help?
Thanks a lot
Could you wrap your IF() with a another IF
IF(ISNULL([Charges]),0[Charges]))
IF(someDate >= FactInovice[start_date] && someDate <=FactInvoice[end_date], IF(ISNULL([charges]),0[Charges]))
Help when you know. Ask when you don't!
I'm still not able to manage this. I could provide dummy pbix if needed.
I don't know how can I check the date in the first IF....I have MIN(FactInvoice[Date]) and MAX(FactInvoice[Date]) but what I need to compare with those?
On the visualisation's x-axes I have DimInvoiceDate[YearNumber] - DimInvoiceDate[MonthNumber] hierarchy and these tables are connected with FactInvoice[Date] (YYYYMM) - DimInvoiceDate[DateKey] (YYYYMM)