topic Re: DAX: Return value from other column in same row in DAX Commands and Tips

DAX: Return value from other column in same row

Anonymous — Thu, 31 Mar 2022 23:45:54 GMT

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?

Re: DAX: Return value from other column in same row

tamerj1 — Fri, 01 Apr 2022 09:20:02 GMT

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.

Re: DAX: Return value from other column in same row

Icey — Tue, 05 Apr 2022 05:59:07 GMT

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

Re: DAX: Return value from other column in same row

Ashoka98 — Tue, 05 Apr 2022 06:26:34 GMT

Hello,

Please use EARLIER function while refereing a where clause