Forum Discussion

Lori001's avatar
Lori001
Frequent Visitor
3 years ago
Solved

DAX code result changes based on column position. How to fix this?

Hi community,   I have a Dax code challenge and don't know how to fix this.   I have a table where I want to calculate the date difference between the columns StartDate and EndDate. The result s...
  • Lori001's avatar
    Lori001
    3 years ago

    Hi binbinyu,

     

    Apoligies for my late reply. Didn't see the notification and I also thought it was marked as spam.

    How I solved the matter was by shifting the columns accordingly. Basically I changed the orders and that allowed me to see what I wanted to see. 

     

    My table had more columns so cannot show it here, but I guess its clear how I solved the matter.

     

    Thank you for your response anyway.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Lori001 ,

This problem may be caused by the data model.

Could you please provide desensitized example data? It is very helpful for me to test.

Thanks for your efforts & time in advance.

 

Best regards,
Community Support Team_Binbin Yu

Lori001's avatar
Lori001
Frequent Visitor
3 years ago

Hi binbinyu,

 

Apoligies for my late reply. Didn't see the notification and I also thought it was marked as spam.

How I solved the matter was by shifting the columns accordingly. Basically I changed the orders and that allowed me to see what I wanted to see. 

 

My table had more columns so cannot show it here, but I guess its clear how I solved the matter.

 

Thank you for your response anyway.