Forum Discussion
Need multiple relations on duplicated table
Hi all
I have a table with objects. There are columns (activeOn = active since) and (DeadOn = inactive from).
I need in a matrix, per month, the number of objects that got active in this month, and the number of objects that got inactive.
I made a DateTable and connected two of the object-tables to it (via yearMonth column):
It works just fine, in my matrix i count ID's from both Tables, i get the correct numbers!
Now there are few (3) columns i.e Format that i encoded in the objects table, so i need my Format Table to decode it.
Even this works, but only for one of the object-tables. For the other Table i still get the correct sum value per month, but cant drill it to the format:
I cant think of a way using only one object-table, but if anyone has an idea, pls let me know.
Thanks
4 Replies
Hi Anonymous ,
It is hard to reproduce your problem, could you please share your pbix file and post your desired result if possible?
Regards,
Daniel He
Hello v-danhe-msft
Yes i can upload it. But it has sensitive data, so before i invest some time to recreate the data, is there any way i can hide the source-data?
In Query editing mode i have some tables filtered or removed columns that are sensitive, but when i share the pbix it can easily be looked into. So i mean can i disable changing the steps?
Hi Anonymous ,
You could just create a simple sample for me and post your desired result, I will try to figure out it.
Regards,
Daniel He
