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.
Hi Experts
Need to amend the following calculated column measure to ignore where we have a empty cell in Uploaded column in the table
Solved! Go to Solution.
@Anonymous
One way to handle this is to use an IF statement to check for blank cells. Try something like:
Period =
VAR p=IF ( ISBLANK[Uploaded]=TRUE(), 0, find("P",'Table'[Uploaded],1))
return
IF(ISBLANK[Uploaded]=TRUE(),"P0", MID('Table'[Uploaded],p+1,100)*1
I am not perfect at writing syntax on the fly, so some adjustments might be necessary. But I hope this points you in the right direction.
Good Luck and Regards,
Try this
Period =
VAR p=find("P",'Table'[Uploaded],1)
return If('Table'[Uploaded]<>blank(), MID('Table'[Uploaded],p+1,100)*1))
@Anonymous
One way to handle this is to use an IF statement to check for blank cells. Try something like:
Period =
VAR p=IF ( ISBLANK[Uploaded]=TRUE(), 0, find("P",'Table'[Uploaded],1))
return
IF(ISBLANK[Uploaded]=TRUE(),"P0", MID('Table'[Uploaded],p+1,100)*1
I am not perfect at writing syntax on the fly, so some adjustments might be necessary. But I hope this points you in the right direction.
Good Luck and Regards,
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |