Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello All,
I need Repeated value in with respect to blank dates below i am showing image with red color values.
.pbix file:
https://drive.google.com/file/d/1p-ryWXkF0kx3VkRRPtiRjccOeja8QohZ/view?usp=sharing
Solved! Go to Solution.
Hi, @mohittimpus
Try measure as below:
Measure2 =
VAR a =
SELECTEDVALUE ( 'Date'[Date] )
VAR b =
CALCULATE (
MAX ( 'Date'[Date] ),
FILTER ( ALL ( 'Date' ), 'Date'[Date] <= a && [M] <> BLANK () )
)
RETURN
CALCULATE ( [M], 'Date'[Date] = b )
Please check my pbix file for more details.
Best Regards,
Community Support Team _ Eason
Hi, @mohittimpus
Try measure as below:
Measure2 =
VAR a =
SELECTEDVALUE ( 'Date'[Date] )
VAR b =
CALCULATE (
MAX ( 'Date'[Date] ),
FILTER ( ALL ( 'Date' ), 'Date'[Date] <= a && [M] <> BLANK () )
)
RETURN
CALCULATE ( [M], 'Date'[Date] = b )
Please check my pbix file for more details.
Best Regards,
Community Support Team _ Eason
@mohittimpus , Try a measure like
calculate([lead expected], filter(allselected(Table), Table[Date] = calculate(Max(Table[Date]), filter(allselected(Table), Table[Date] <=max(Table[Date]) && not (isblank([lead expected]))))))
User | Count |
---|---|
83 | |
77 | |
71 | |
70 | |
54 |
User | Count |
---|---|
107 | |
98 | |
86 | |
79 | |
67 |