DAX: Return value from other column in same row

[Anonymous]

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)])>=_startDate

RETURN

IF(_period,_program)

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?

[Ashoka98]

Hello,

Please use EARLIER function while refereing a where clause

[Icey]

Hi @Anonymous ,

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", "Roadmap DB" and "Memory Data"? 

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.

Reference: 

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

Best Regards,

Icey

[tamerj1]

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