DAX: Return value from other column in same row

Question

Hi,I am working on a matrix based gantt chart in Power BI and instead of 1 I wanted to return value from other column but from same row:Time Period = VAR _program = CALCULATE(MAX('Roadmap DB'[Program]))VAR _startDate=CALCULATE(MIN('Memory Data'[Start]),ALL('Calendar'))VAR _period= MIN('Calendar'[Start Date(Cal)])&gt;=_startDateRETURNIF(_period,_program)&nbsp;But its getting value from whole table instead of particular column, is there a way to get the value only from the row in question?

tamerj1 · Answer

Hi&nbsp;Anonymous&nbsp;Please provide sample data along with the expected result. Also please provide screenshot of your data model and advise the columns involved&nbsp;in the relationships.

icey · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
What's the data structure of your tables of "Roadmap DB" and "Memory Data"? And how do you create relationships among the three tables of "Calendar",&nbsp;"Roadmap DB" and "Memory Data"?&nbsp;
&nbsp;
Please create a simple sample to help us understand your model and please show us your expected result. Please don't contain any sensitive information.
&nbsp;
Reference:&nbsp;
How to Get Your Question Answered Quickly - Microsoft Power BI Community
How to provide sample data in the Power BI Forum - Microsoft Power BI Community
&nbsp;
&nbsp;
Best Regards,
Icey

ashoka98 · Answer

Hello,&nbsp;Please use EARLIER function while refereing a where clause

Forum Discussion

DAX: Return value from other column in same row

3 Replies

Related content

Return Column Name if Zero Value

Measure returning incorrect value

Date Different return wrong value

SUMX(VALUES(column), [Measure]) returns parent-level value, while ADDCOLUMNS/SUMMARIZECOLUMNS works

Create measure to return value from column when condition met for two other columns