Forum Discussion

yoav20007's avatar
yoav20007
Icon for Helper II rankHelper II
8 years ago
Solved

help with dax calculate column

I need to create calculate column  that add the last day rate if it is empty. I need that all date have rates . Thanks !!!   date                rate      all rates 1/11/17           5 2/11/17  ...
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi yoav20007,

     

    Why don't you do this in the query editor.

     

    Insert a custom column with the following syntax: 

    All Rates = [Rate]

     

    Then right click on the new column header and select fill down final result below:

     

    Regards,

    MFelix

     

yoav20007's avatar
yoav20007
Icon for Helper II rankHelper II
8 years ago

Thanks again Zubair_Muhammad but ...

Almost :) 

that's the result. after the first time it dosn't works.

MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

Hi yoav20007,

 

Why don't you do this in the query editor.

 

Insert a custom column with the following syntax: 

All Rates = [Rate]

 

Then right click on the new column header and select fill down final result below:

 

Regards,

MFelix

 

  • yoav20007's avatar
    yoav20007
    Icon for Helper II rankHelper II
    8 years ago

    Hi MFelix Thank you.

     

    Because it to simple and i didn't think about that :)