Forum Discussion
Using Inactive Relationship to Fill Gaps in Data
Hello Everyone, I am trying to use an inactive relationship to fill gaps in my data. I have a fact table and a dimension table. There are two relationships, 1 active and 1 inactive, pictured belo...
I tried it, and I was unable to use COALESCE so I just used ISBLANK instead. This is what happened when I tried it:
I changed my data table titles to match your use of them