Forum Discussion

Help_Please's avatar
Help_Please
New Member
2 years ago

ADD NEW COLUMN with DAX throwing error

I have created a PBIX File on desktop with multiple tables. Out of those I have created an active relationship between 2 tables, Table A & Table B. Relationship between A&B is Many to One (Both) card...
Help
Urgent
govindarajan_d's avatar
govindarajan_d
Icon for Super User rankSuper User
2 years ago

Hi Help_Please,

 

Can you try like this:

New Column = MAXX(FILTER(
'TABLE A','TABLE A'[Date]>=RELATED('TABLE B'[Migration Date])&&
'TABLE A'[Date]<=RELATED('TABLE B'[Exit Date])&&
'TABLE A'[Unique Code]=RELATED('TABLE B'[Unique Code])&&
'TABLE A'[Cluster Code]=RELATED('TABLE B'[Cluster Code])),
'TABLE B'[Name])
  • Help_Please's avatar
    Help_Please
    New Member
    2 years ago

    Thank you for your response.

    I did actually try the formula mentioned by you but unfortunately it is not giving the correct return values so although it doesn't throw an error but it is also not able to give me accurate results. I was wondering if there is a bug and if there was a way to diagnose that in my PBIX File. 

    • govindarajan_d's avatar
      govindarajan_d
      Icon for Super User rankSuper User
      2 years ago

      Hi Help_Please,

       

      You are trying to run the MAXX function on name. Any specific reason?

      Can you provide the pbix file with sensitive data removed?

      • Help_Please's avatar
        Help_Please
        New Member
        2 years ago

        MAXX function I have used as an aggregator function so that it can return the exact value basis the conditions set. Somehow this formula works in another PBIX file but this file it is not able to return value. It's because it is not able to read the Table B and it's columns. I feel if I can resolve that the formula would also start working.

        About sharing PBIX File, unfortunately, my company policies do not permit us to share any information including files with dummy data with outside company 😞