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 have a csv file in the below format:
Timestamp Vehicle speed Fuel Level RPM
Timestamp Fuel Level
4/3/2016 12:28 49.2
4/3/2016 12:30 48.8
4/3/2016 12:32 48.8
4/3/2016 12:35 0
4/3/2016 12:37 0
4/3/2016 12:39 0
4/3/2016 12:40 48.8
4/3/2016 12:45 48
In the above table the fuel level goes to zero. I would like to replace the zeros with the pervious row value.
Any help is appreciated.
Thank you.
Solved! Go to Solution.
are they nulls or 0
if 0 then replace them with null as below and use Fill option with Down
here is the final result
hope this helps
are they nulls or 0
if 0 then replace them with null as below and use Fill option with Down
here is the final result
hope this helps
what if I have the exact scenario in a calculated table? how can I use FILL option in DAX? I am trying usnig EARLIER or EARLIEST without success.
Hi @Anonymous,
Show your data and the expected result.
please, see below what I have and what I need, using DAX.
attention to holidays midweek.
date | weekday | values I have | values I need |
01/nov | Wednesday | 1 | 1 |
02/nov | holiday | 1 | |
03/nov | Friday | 2 | 2 |
04/nov | Saturday | 2 | |
05/nov | Sunday | 2 | |
06/nov | Monday | 3 | 3 |
07/nov | Tuesday | 4 | 4 |
08/nov | Wednesday | 5 | 5 |
09/nov | Thursday | 6 | 6 |
10/nov | Friday | 7 | 7 |
11/nov | Saturday | 7 | |
12/nov | Sunday | 7 | |
13/nov | Monday | 8 | 8 |
14/nov | Tuesday | 9 | 9 |
15/nov | holiday | 9 | |
16/nov | Thursday | 10 | 10 |
17/nov | Friday | 11 | 11 |
18/nov | Saturday | 11 | |
19/nov | Sunday | 11 | |
20/nov | Monday | 12 | 12 |
21/nov | Tuesday | 13 | 13 |
Hi,
I don't think i can solve this in DAX. Thr easiest way would be to use the Query Editor.
Hi, I want to replace my blanks into word "Blanks" so that I can show them in the slicer as blanks itself as one line item, is it possible ??
I have list of word in the 1st column
column1
Apple
Bag
Car
<- Blank
Echo
Expecting Output:
column
Apple
Bag
Car
(Blank)
Echo
Thank you in advance
Hi @Vipin,
You need to:
- Go to the query editor, click on the "Level" column and transform its type to text instead of number --> this will let you catch all zeroes
- Add a custom column "Level_New" having the following syntax: if [level]="0" then "" else [level] --> this will let you replace all zeroes with blanks
- Change Level_New type to decimal number --> this will give the value null to all blank fields
- Select the column Level_New and under Transform/Any Column, click on Fill/Down --> this will fill all null fields with the value of the field above
Hope it helps!
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 |