Forum Discussion

Anonymous's avatar
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...
Need Help
  • Anonymous's avatar
    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!

v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

Anonymous,

 

You may also try SUMX Function to add a measure directly.

Anonymous's avatar
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!