Forum Discussion
DAX Will Not Reference Columns
Hi All, I have two tables: - Table A: contains project information such as ID, start date, end date, etc. These are all columns. - Table B: contains financial information such as Total Actuals,...
WinterMist
Impactful Individual
Impactful Individual
Sorry to hear you are locked out from creating calculated columns.
You can create the measure in the following way.
However, you will need to combine the columns from both Table A & Table B into the same table visual.
This is because measures calculate at the report level and not at the row level.
NOTE: I left the calculated column (C1 Calc) in the table visual for comparison with the measure (M1 Calc).
Let me know if this is helpful to you.
Regards,
Nathan