Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hello everyone,
I'm new using Power BI. Especifically Power Pivot. I hope that you can help me. I have 5 tables as you can see below:
The table of RANGING_TGT basically has a column of objectives (RANGETGT) that contains 0 and 1. Those products that have a one are those to which focus is sought. THE DYNAMIC TABLE I AM DOING LOOKS LIKE THIS (in yellow RANGE_TGT):
The problem is that there are times that old products are sold that never had focus and therefore when matching RANGING TGT they are left blank. My question is how can I force those blank cells to be 0.
Thanks a lot for your time