Forum Discussion
Anonymous
7 years agoNot applicable
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, ...
v-danhe-msft
7 years agoMicrosoft Employee
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
Anonymous
7 years agoNot applicable
v-danhe-msft Example file available here: https://www.dropbox.com/s/1fnl666ysic6c2h/example.pbix?dl=0
(What is the best way to upload/show pbix files btw?)
The file:
You see 2 tables. The top one is my current situation, bottom one the expected numbers for the "ActiveOn" column.
I tried to keep it as simple as possible so i hope you understand it.