Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm with a prblema I hope eplicar clearly.
I have a dw with varis facts and all the facts has several fields in common, one of these fields is the month_id.
I make the burden of these facts in my power bi application and then concatenate all to become one fact only.
the problem is when I do some filters, as reported not all facts have the same fields with month_id and when I filter a month has indicators that due to have a field of a fact that had not month_id the indicator in question is null, I tried to add the month_id in all facts before concatenate however is not possible.
Any suggestions how to solve this?
I make the burden of these facts in my power bi application and then concatenate all to become one fact only.
the problem is when I do some filters, as reported not all facts have the same fields with month_id and when I filter a month has indicators that due to have a field of a fact that had not month_id the indicator in question is null, I tried to add the month_id in all facts before concatenate however is not possible.
According to your description, the problem with filters may related to that not all facts have the same fields with month_id. So adding the month_id in all facts may solve the issue. What do you mean “add the month_id in all facts before concatenate however is not possible”? Where the problem occurs when you try to add the month_id in all facts? Does it throw any error? It will be better if you could post some sample data.
Regards
Hi @vitexo87. Can you post a picture or sample of your table structure and where the problem occurs? Thanks.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |