Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
3/11/17
4/11/17 4
5/11/17
6/11/17 4.8
Solved! Go to Solution.
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @yoav20007
Try this calculated column
= VAR Daybefore = PREVIOUSDAY ( Table1[date] ) RETURN IF ( ISBLANK ( Table1[Rates] ), CALCULATE ( VALUES ( Table1[Rates] ), FILTER ( ALL ( Table1 ), Table1[date] = Daybefore ) ), Table1[Rates] )
Thanks @Zubair_Muhammad
But when i have more than 1 day blanks rates it's dosn't work.
I need to repeat the same rate
Hi @yoav20007
Try this
= IF ( ISBLANK ( Table1[Rates] ), CALCULATE ( LASTNONBLANK ( Table1[Rates], Table1[Rates] ), FILTER ( Table1, Table1[date] < EARLIER ( Table1[date] ) ) ), Table1[Rates] )
Thanks @Zubair_Muhammad
I try .
But it dosn't works. That's the result . the same number for all of them.
@yoav20007
Hmmm!!!! May be this one
= IF ( ISBLANK ( Table1[Rates] ), CALCULATE ( LASTNONBLANK ( Table1[Rates], Table1[Rates] ), FILTER ( Table1, Table1[date] < EARLIER ( Table1[date] ) && Table1[date] > MIN ( Table1[date] ) ) ), Table1[Rates] )
Thanks again @Zubair_Muhammad but ...
Almost 🙂
that's the result. after the first time it dosn't works.
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Portuguêshow to replace 0 with earlier value?
test = IF(ISBLANK(sales[rate])=TRUE(),0,sales[rate])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |