Forum Discussion

Anonymous

Not applicable

8 years ago

Solved

Logical operations between two tables

Hi! I have 2 tables: Table A: document | start date | end date | Yearmonth Table B: document | date | Yearmonth Table A had duplicates so I created a referenced table to table A grouping by doc...

Anonymous
8 years ago
Ok, I solved like this:
New column-> Time_ok = IF ( 'Table B'[date]< RELATED ( 'Table A'[max_date] ) ) ;1;0 )

And new measure to get the percentages:

New Measure -> % tiempo = DIVIDE(SUM('Table B'[Time_ok]);count('Table B'[document]))

It seems to work, buy I'm new to Power BI so I'd like to know if there is a better solution.
Thank you!

Anonymous

Not applicable

8 years ago

Ok, I solved like this:

New column-> Time_ok = IF ( 'Table B'[date]< RELATED ( 'Table A'[max_date] ) ) ;1;0 )

And new measure to get the percentages:

New Measure -> % tiempo = DIVIDE(SUM('Table B'[Time_ok]);count('Table B'[document]))

It seems to work, buy I'm new to Power BI so I'd like to know if there is a better solution.

Thank you!

v-chuncz-msft
Community Support
8 years ago
Anonymous,

You may also try SUMX Function to add a measure directly.
- Anonymous
  Not applicable
  8 years ago
  Great! but I think will lost readeability if I continue to nest functions (because I'm new and want to understand my code in 2 weeks, when I advance furter I'll begin using your method), thanks!