Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi ,
I m new to power bi ,I have below dataset. In Target 2 column , blank values filled with previous value.Please help me to write dax for same.
Year-Week | TARGET | TARGET2 |
2020-25 | 14112 | 14112 |
2020-26 | 14112 | |
2020-27 | 10872 | 10872 |
2020-28 | 10872 | |
2020-29 | 10872 | |
2020-30 | 8928 | 8928 |
Thanks
Solved! Go to Solution.
@Anonymous
You can use the below Measure, I only changed the EARLIER function to MAX.
Measure_Filldown =
VAR LNBT =
CALCULATE(MAX('Table'[YEAR-WEEK]),
FILTER(
ALL('Table'),
'Table'[YEAR-WEEK]<=MAX('Table'[YEAR-WEEK]) && 'Table'[TARGET]<>BLANK()
)
)
RETURN
CALCULATE(
MAX([TARGET]),
'Table'[YEAR-WEEK] = LNBT ,ALL('Table')
)
Did I answer your question? Mark my post as a solution!
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |