Forum Discussion
Creating Calculated Column Based on Measure
Hi Everyone,
I'm trying to create a calculated column based on either a measure or a column in another table. I have tried both methods below and in both cases the column only calculates off the first condition and I get this result every time: 'T Tests'[Timepoint 1] - 'T Tests'[Timepoint 2])
Method 1: Creating conditional calculated column using a calculated measure in the same table
1 Reply
eHorizons Basing a calculated column on a measure will not work generally as measures are dynamic but calculated columns are only calculated at the time of data load. If basing this on a column from another table, generally use RELATED or LOOKUPVALUE or MAXX(FILTER(...), ...). Hard to be specific without sample data.
Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
