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

how to replace 0 with earlier value?

test = IF(ISBLANK(sales[rate])=TRUE(),0,sales[rate])