The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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])
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
261 | |
120 | |
113 | |
83 | |
71 |