cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Problems to replace blank values

Hello everyone,

I have a table with a historical quote of currencies, as you can see there are dates with blank values, usually are the holidays, but I need this field to have the value of the last day that has quoted the currency.

King Regards

1 ACCEPTED SOLUTION
Resolver III

Hi ,

Not sure what extactly you are looking for but as per your screenshot it looks like to want to fill the blanks with previous day value.

To do so , Edit query --> Select  eur_usd column --> Go to "Transform" tab --> select Fill down option from FILL.

2 REPLIES 2
Resolver III

Hi ,

Not sure what extactly you are looking for but as per your screenshot it looks like to want to fill the blanks with previous day value.

To do so , Edit query --> Select  eur_usd column --> Go to "Transform" tab --> select Fill down option from FILL.

Frequent Visitor

Hello,

the problem is that I am working on a calculated table, but thanks to your answer I was able to find a solution in the community, it is the following:

```new eur_usd =
VAR LastNonBlankDate =
CALCULATE(LASTNONBLANK(cotizaciones[Date];1);
FILTER(
ALL(cotizaciones);
cotizaciones[Date]<=EARLIER(cotizaciones[Date])
&& NOT( ISBLANK(cotizaciones[eur_usd]) )
)
)
return
CALCULATE(
SUM(cotizaciones[eur_usd]);
FILTER( ALL(cotizaciones); cotizaciones[Date] = LastNonBlankDate)
)                       ```

As you can see the result is fantastic ...

The solution I found in:

http://community.powerbi.com/t5/Desktop/Dax-fill-down-in-formula/td-p/318991

Thank you very much for helping me find the solution

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.